Very Computer

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?

TIA,

Joe

Maybe I solved my own problem by reading BOL a little more carefully.  I
think I'll try bitwise OR ( | ).

Joe

Quote:> 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?

> TIA,

> Joe