WvdS Doku - it:int:dbgway:anwender:access https://www.wvds.it/wiki/ 2026-05-22T16:09:08+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:44+00:00 Anonymous (anonymous@undisclosed.example.com) 2.2 Query con Tabelle Collegate https://www.wvds.it/wiki/doku.php?id=it:int:dbgway:anwender:access:abfragen&rev=1769728964&do=diff 2.2 Query con Tabelle Collegate Query SQL sui dati Gateway in Access. Query Semplice 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:22:34+00:00 Anonymous (anonymous@undisclosed.example.com) 2. Access https://www.wvds.it/wiki/doku.php?id=it:int:dbgway:anwender:access:start&rev=1769728954&do=diff 2. Access text/html 2026-01-29T23:22:56+00:00 Anonymous (anonymous@undisclosed.example.com) 2.1 Tabelle Collegate in Access https://www.wvds.it/wiki/doku.php?id=it:int:dbgway:anwender:access:verknuepfte-tabellen&rev=1769728976&do=diff 2.1 Tabelle Collegate in Access Integrare dati dal Gateway come tabelle collegate. Prerequisiti * Access 2016 o successivo * Accesso di rete al Gateway Istruzioni * Dati esterni -> Nuova origine dati -> Da servizi online -> Feed OData * Inserire