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