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 REFNO>Tore,
>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 >>
>WHERE SUPPNAME LIKE 'ABC%' >>It generates an error both on the VFP side, and on MySQL Query Browser.
>WHERE B.DESCRIPTOR LIKE 'ABC%' >>It works on MySQL Query Browser. In VFP side though, it first shows an error (trapped by my code) first (Unknown column in where clause), but show the correct results.