At 05/11/2002 02:59 PM, you wrote:

>I'm confused. My query doesn't have a WHERE clause in it. How can I fix
>this? This is what I'm sending.
>
>*************************************************
>Select mc.MenuCategoryID, mi.MenuItemID, mc.CategoryName, mi.ItemCode,
>mi.ItemName, mi.Price, mi.Sales
> From xMenuCategory mc JOIN xMenuItem mi
>ON (mc.MenuCategoryID = mi.MenuCategoryID)
>and (mc.LocationID = 2)
>and (mi.LocationID = 2)
>ORDER BY mc.CategoryName, mi.ItemCode
>*************************************************

Change the 2 lines:
and (mc.LocationID=2)
and (mi.LocationID=2)

to:
WHERE (mc.LocationID=2) and (mi.LocationID=2)


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)