Hi to all,
I have the following error
"Syntax error in JOIN operation"

this.oleDbCommand1.CommandText = "select Item from (((SELECT 1 as sortorder, PrimaryMenu.PrItems as Item FROM PrimaryMenu where PrimaryMenu.MenuID=1) union (SELECT 2 as sortorder, Category.CategoryName as Item FROM (Category INNER JOIN PrimaryMenu ON Category.MenuID = PrimaryMenu.MenuID) WHERE (PrimaryMenu.MenuID=1))))";

I use an Access database.
What the cause of the error?
Thanks.

hi,

"SELECT 2 as sortorder, Category.CategoryName as Item
FROM Category INNER JOIN PrimaryMenu ON Category.MenuID = PrimaryMenu.MenuID
 WHERE (PrimaryMenu.MenuID=1)"

Does this part work fine indipendently


Prashant