SELECT c.CustomerID, c.Surname, c.Address, c.Town, c.Postcode, 
o.OrderID, o.Date, 
 i.ProductID, i.Qty, p.Description FROM Customer c 
   JOIN ORDER o ON c.CustomerID = o.CustomerID
     JOIN Item i ON o.OrderID = i.OrderID
       JOIN Product p ON i.ProductID = p.ProductID
         WHERE WarehouseID='Manchester' AND Date='02/06/2008'

SELECT c.CustomerID, c.Surname, c.Address, c.Town, c.Postcode, 
o.OrderID, o.Date, i.ProductID, i.Qty, p.Description 
 FROM Customer c, ORDER o, Item i, Product p  
   WHERE c.CustomerID = o.CustomerID
    AND  o.OrderID = i.OrderID
      AND i.ProductID = p.ProductID
        AND WarehouseID='Manchester' AND Date='02/06/2008'

SELECT Customer.CustomerID, Customer.Surname, Customer.Address, 
    Customer.Town, Customer.[Post code], 
    ORDER.OrderID, ORDER.Date, Item.[Products ID], 
    Item.Qty, Products.Description, 
    Products.[Unit Price], ORDER.WarehouseID
        FROM Products 
        INNER JOIN ((Customer 
        INNER JOIN [ORDER] ON Customer.CustomerID = ORDER.CustomerID) 
        INNER JOIN Item ON ORDER.OrderID = Item.[ORDER ID]) ON Products.ProductsID = Item.[Products ID]
            WHERE (((ORDER.Date)=#2/6/2008#) AND ((Order.WarehouseID)="Manchester"));

SELECT Description, ProductsID FROM Products WHERE Qty < '5';

SELECT Customer.*, ORDER.*
FROM Customer INNER JOIN [ORDER] ON Customer.CustomerID = ORDER.CustomerID
WHERE (((ORDER.Date)=#6/2/2008#) AND ((Order.WarehouseID)="manchester"));

SELECT *
FROM Products
WHERE (((Qty)<"5"));
 

SELECT Customer.CustomerID, Customer.Surname, Customer.Address, Customer.Town, Customer.[Post code], ORDER.OrderID, ORDER.Date, ORDER.WarehouseID
FROM Customer INNER JOIN [ORDER] ON Customer.CustomerID = ORDER.CustomerID
WHERE (((ORDER.Date)=#6/2/2008#) AND ((Order.WarehouseID)="manchester"));

SELECT [Stock].[WareHouseID], [Stock].[ProductsID], [Stock].[Qty], [Products].[Description]
FROM Stock INNER JOIN Products ON [Stock].[ProductsID]=[Products].[ProductsID]
WHERE ((([Stock].[Qty])<5) AND (([Stock].[WarehouseID])="London"));