Hi, all.  I built this SQL Statement in Access97.  I want to rephrase it
to use it in MySQL3.23.   The problem is I don't know the correct
syntax.  Any help will be really appreciated. Thanks.

SELECT 
        bnkrestaurants.sRest, 
        bnkdetailpos.dTransDate, 
        bnkdetailpos.sTerminalNo, 
        bnkcardtypes.sCardDescr, 
        bnkdetailpos.sCardNo, 
        bnkdetailpos.nAmount, 
        bnkdetailpos.sTransType
FROM 
        (bnkrestaurants 
        RIGHT JOIN (bnkterminals 
        RIGHT JOIN (bnkdetailpos 
        INNER JOIN refundcards 
                ON bnkdetailpos.sCardNo = refundcards.scardno) 
                ON bnkterminals.sTerminalNo = bnkdetailpos.sTerminalNo) 
                ON bnkrestaurants.sMerchNo = bnkterminals.sMerchNo) 
                INNER JOIN bnkcardtypes 
                        ON bnkdetailpos.sCardType =
bnkcardtypes.sCardType

Reply via email to