WvdS Doku - sl:int:dbgway:anwender:access https://www.wvds.it/wiki/ 2026-05-22T17:20:27+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:22:46+00:00 Anonymous (anonymous@undisclosed.example.com) 2.2 Poizvedbe s povezanimi tabelami https://www.wvds.it/wiki/doku.php?id=sl:int:dbgway:anwender:access:abfragen&rev=1769728966&do=diff 2.2 Poizvedbe s povezanimi tabelami SQL poizvedbe na Gateway podatkih v Accessu. Enostavna poizvedba SELECT * FROM Customers WHERE Country = 'Germany' ORDER BY Name; Povezava 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:22:40+00:00 Anonymous (anonymous@undisclosed.example.com) 2. Access https://www.wvds.it/wiki/doku.php?id=sl:int:dbgway:anwender:access:start&rev=1769728960&do=diff 2. Access text/html 2026-01-29T23:23:00+00:00 Anonymous (anonymous@undisclosed.example.com) 2.1 Povezane tabele v Accessu https://www.wvds.it/wiki/doku.php?id=sl:int:dbgway:anwender:access:verknuepfte-tabellen&rev=1769728980&do=diff 2.1 Povezane tabele v Accessu Vključitev podatkov iz Gateway kot povezane tabele. Predpogoji * Access 2016 ali novejši * Omrežni dostop do Gateway Navodila * Zunanji podatki → Nov vir podatkov → Iz spletnih storitev → OData-Feed *