Invoices

SELECT     * 
FROM     INVOICES 

This only works in SQL Server as there is no (nolock) feature in Access

SELECT     * 
FROM     INVOICES (nolock) 

This works in both SQL Server and Access becuase Quantity is a numerical field

SELECT     * 
FROM     INVOICES 
WHERE     Quantity  BETWEEN 50 AND 60 

This works in both SQL Server and Access

SELECT     Country 
      ,COUNT(Country) 
FROM     INVOICES 
GROUP BY    Country 
HAVING     Country = 'Denmark'  
ORDER BY    Country ASC 

This works in both SQL Server and Access

SELECT     * 
FROM     INVOICES I 
INNER JOIN    CUSTOMERS 
ON      Customers.CustomerID = I.CustomerID 
WHERE     I.City = 'Lyon'