I have a search on my aspx page that allows users to search and OEM Part Number.
This Number could be an OEMPartNumber or OEMSubnumber or OEMSubNumber2.
It needs to match my AMIPartNumber Table to OEMItem and Display Item (which is my part number)
Here is what i have but giving me no results
EnterNumber is my textbox on form
SELECT * ,
FROM JD as I
INNER JOIN amipartnumbers as AMIA
ON AMIA.OEMItem = I.OEMPartNumber
INNER JOIN amipartnumbers as AMIB
ON AMIB.OEMItem = I.OEMPartNumber
INNER JOIN amipartnumbers as AMIC
ON AMIC.OEMItem = I.OEMSubNumber2
where coalesce(I.OEMPartNumber,I.OEMSubNumber,I.OEMSubNumber2)= '" & enterNumber & "'