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 REFNOAs you can see from the above code, B.DESCRIPTOR has an alias of SUPPNAME. If I use:
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.