Thread: Ambiguous column error

Hi,

I have the following in my asp page and getting the error below.

Code:

SELECT     dbo.tblTest.Equipment
FROM         dbo.tblScrap FULL OUTER JOIN dbo.tblTest 
ON dbo.tblScrap.Equipment = dbo.tblTest.Equipment
where Equipment = '" & strEQNumber & "'

Code:

Error:
Ambiguous column name 'Equipment'.

when i run the select statement in the sql2000 analyzer i get the results i want but here when i add the WHERE having the error. im trying to check both table for the equiment.

ok...got it...guess have to use the dbo part...like so and then i added OR to check in both tables...wanted to make sure to see if equipment exists in either table.

Code:

where dbo.tblTest.Equipment = '" & strEQNumber & "' or dbo.tblScrap.Equipment = '" & strEQNumber & "'"