WvdS Doku - en:int:dbgway:anwender:access https://www.wvds.it/wiki/ 2026-05-22T16:45:40+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:23:26+00:00 Anonymous (anonymous@undisclosed.example.com) 2.2 Queries with Linked Tables https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:access:abfragen&rev=1769729006&do=diff 2.2 Queries with Linked Tables SQL queries on Gateway data in Access. Simple Query SELECT * FROM Customers WHERE Country = 'Germany' ORDER BY Name; Join 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:23:02+00:00 Anonymous (anonymous@undisclosed.example.com) 2. Access https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:access:start&rev=1769728982&do=diff 2. Access text/html 2026-01-29T23:23:12+00:00 Anonymous (anonymous@undisclosed.example.com) 2.1 Linked Tables in Access https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:access:verknuepfte-tabellen&rev=1769728992&do=diff 2.1 Linked Tables in Access Include data from the Gateway as linked tables. Prerequisites * Access 2016 or newer * Network access to Gateway Instructions * External Data -> New Data Source -> From Online Services -> OData Feed * Enter URL