Hi All,
I would like to know whether it's possible to write a select query with where clause having fields that might not be present in the same table? For example there is a table PO and it might not have ITEMSETID field but has ORGID field and there is some other table which might have ORGID and does not have ITEMSETID field . I tried to execute like
SELECT * FROM PO WHERE RECEIPTS ='NONE' and ( ITEMSETID ='XXXX' or ORGID ='YYYY')