Hi All,

I'm getting an error with the following query using IBO v4.21:

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
Order by mc.CategoryName, mi.ItemCode

However, Marathon v2.0 (which uses IBO 3.4.Ca) executes it just fine.

The error is:
****************************************************************************
**
Project xxxxx.exe raised exception class EIBO_ISCError with message 'ISC
ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -204
Ambiguous field name between table XMENUCATEGORY and table XMENUITEM
LOCATIONID

STATEMENT:
TIBOInternalDataset:"<TApplicatoin>.DM.qryManSales.IBOqrqryManSales.'.
****************************************************************************
**

Am I doing something wrong or is this a bug in IBO?

Thanks,
Steve