2.2 Poizvedbe s povezanimi tabelami

SQL poizvedbe na Gateway podatkih v Accessu.

SELECT * FROM Customers
WHERE Country = 'Germany'
ORDER BY Name;

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#;

Filtri se posredujejo strežniku - velike količine podatkov se ne naložijo lokalno.

SELECT Country, COUNT(*) AS Stevilo
FROM Customers
GROUP BY Country;