I'm trying to something like this to work, but I keep getting "Invalid
syntax near keyword 'OR'"?
SELECT Cust.Promo OR Item.Promo AS IsPromo
FROM Cust INNER JOIN Orders ON Cust.CustID = Orders.CustID
INNER JOIN OrderItem ON Orders.OrderID = OrderItem.OrderID
INNER JOIN Item ON OrderItem.ItemID = Item.ItemID
Forget the 'FROM' clause, the problem's in using 'OR' in the select list.
First, can this be done, and second, what would be the correct syntax?