what happens if you replace b.descriptor with pohdr.descriptor? Even better, what happens if you replace all As and Bs with for instance AA and BB, in order to avoid single letter aliases? Like this:SELECT AA.REFNO, AA.DATE, AA.SUPPLIERID, AA.TERMS, AA.TOTQTY, AA.AMOUNT, AA.REMARKS,
AA.PREPAREDBY, AA.CHECKEDBY, AA.PRINTDATE, AA.POSTDATE, AA.CLOSED, AA.CANCELLED, AA.ID,
BB.CODE AS SUPPCODE, BB.DESCRIPTOR AS SUPPNAME, BB.ADDRESS AS SUPPADDR
FROM pohdr AA JOIN SUPPLIER BB ON AA.SUPPLIERID=BB.ID WHERE BB.DESCRIPTOR LIKE 'ABC%'
ORDER BY REFNOStill the same error sir. =(
