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