SELECT FROM Amibiguous Column Name

[guest]

Hi,

I have the following SQL:

SELECT WO.WONUM, WO.UD1, WOEQLIST.UD2, WO.TASKNUM
FROM WO, WOEQLIST
WHERE WONUM not in (select distinct WONUM from WOP) And UD1 Is Not Null And UD2 <>'9000' And UD2 <>'9001' And TASKNUM Like '%STK%'

I keep on getting ambiguous column name 'WONUM', 'UD1' and 'UD2', statement could not be prepared.

I do not know why this is happening - there are definitely columns with this name in WO. Please help!

 

[guest]

I realise that it is because WONUM and UD1 & UD2 also exist in WOEQLIST, but I am differentiating which table each should come out of in the code. Why does it not identify this?