WvdS Doku - hr:int:dbgway:anwender:access https://www.wvds.it/wiki/ 2026-05-22T16:45:59+00:00 WvdS Doku https://www.wvds.it/wiki/ https://www.wvds.it/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2026-01-29T23:24:12+00:00 Anonymous (anonymous@undisclosed.example.com) 2.2 Upiti s povezanim tablicama https://www.wvds.it/wiki/doku.php?id=hr:int:dbgway:anwender:access:abfragen&rev=1769729052&do=diff 2.2 Upiti s povezanim tablicama SQL upiti na Gateway podacima u Accessu. Jednostavni upit SELECT * FROM Customers WHERE Country = 'Germany' ORDER BY Name; Spajanje SELECT c.Name, o.OrderDate, o.Total FROM Customers AS c INNER JOIN Orders AS o ON c.Id = o.CustomerId WHERE o.OrderDate > #2024-01-01#; text/html 2026-01-29T23:24:02+00:00 Anonymous (anonymous@undisclosed.example.com) 2. Access https://www.wvds.it/wiki/doku.php?id=hr:int:dbgway:anwender:access:start&rev=1769729042&do=diff 2. Access text/html 2026-01-29T23:24:28+00:00 Anonymous (anonymous@undisclosed.example.com) 2.1 Povezane tablice u Accessu https://www.wvds.it/wiki/doku.php?id=hr:int:dbgway:anwender:access:verknuepfte-tabellen&rev=1769729068&do=diff 2.1 Povezane tablice u Accessu Uključivanje podataka iz Gatewaya kao povezanih tablica. Preduvjeti * Access 2016 ili noviji * Mrežni pristup Gatewayu Upute * Vanjski podaci → Novi izvor podataka → Iz online usluga → OData-Feed * Unijeti