SQL Old style outer joins
SQL
Download (.zip)
SELECT 'Customers.Cust_ID'=Customers.Cust_ID, Customers.Cust_Name, 'Orders.Cust_ID'=Orders.Cust_ID FROM Customers, Orders WHERE Customers.Cust_ID *= Orders.Cust_ID AND (Customers.Cust_ID <> 2 OR Orders.Cust_ID IS NULL)
SELECT 'Customers.Cust_ID'=Customers.Cust_ID, Customers.Cust_Name, 'Orders.Cust_ID'=Orders.Cust_ID FROM Customers, Orders WHERE Customers.Cust_ID *= Orders.Cust_ID AND Customers.Cust_ID <> 2
|