Hmm, try this version
>>SELECT A.REFNO, A.DATE, A.SUPPLIERID, A.TERMS, A.TOTQTY, A.AMOUNT, A.REMARKS,
> A.PREPAREDBY, A.CHECKEDBY, A.PRINTDATE, A.POSTDATE, A.CLOSED, A.CANCELLED, A.ID,
> B.CODE AS SUPPCODE, B.DESCRIPTOR AS SUPPNAME, B.ADDRESS AS SUPPADDR
>FROM pohdr A JOIN SUPPLIER B ON A.SUPPLIERID=B.ID WHERE B.`DESCRIPTOR` LIKE 'ABC%'
>ORDER BY REFNO
>
>
>Still no luck! What I do not get is it will show an ODBC error message (Unknown Column ... in 'where clause' ), but show the correct results~!
>
>Dennis
You write that you get the correct result. Are you sure that you see a different result, and not the result from the previous attempt?
