Shouldn't this work? I am trying to select all customers, whether they have placed an order or not. (Using Access 2010)
SELECT fname, lname, Order.id
FROM Customer OUTER JOIN Order
WHERE Customer.id = Order.cust_id;
I have also tried INNER JOIN, =*, *= and changing the WHERE to ON. All return a syntax error in FROM clause.