DA Search ambiguous field name
I have recordset based on 3 tables..
SELECT tblitems.ItemID, tblitems.StockNumber AS ItemStockNumber, tblitems.ItemDiscountGroup, tblpriceinventory.Price, tblpriceinventory.StockLevel, tblitems.ItemName, tblitemcategory.CategoryID FROM tblitems JOIN (tblitemcategory JOIN tblcategory ON tblitemcategory.CategoryID = tblcategory.CategoryID) ON tblitems.ItemID = tblitemcategory.ItemID LEFT JOIN tblpriceinventory ON tblitems.StockNumber = tblpriceinventory.StockNumber
When I try to use the DA search wizard, when the result page loads I get the error "Column 'StockNumber' in where clause is ambiguous", even though I have given it an alias