title: MULTIPLE JOIN IN MS ACCESS
body: <pre><code>SELECT VISA41717.Fraud_Post_Date,
         VISA41717.Merchant_Name_Raw,
         VISA41717.Merchant_City,
         VISA41717.Merchant_Country,
         VISA41717.Merchant_Category_Code,
         VISA41717.ARN,
         VISA41717.POS_Entry_Mode,
         VISA41717.Fraud_Type,
         VISA41717.Local_Amt,
         VISA41717.Fraud_Amt,
         VISA41717.Purch_Date,
         VISA41717.Currency_Code,
         VISA41717.Cashback_Indicator,
         VISA41717.Card_Account_Num,
         BIN.BANK,
         BIN.COUNTRY
  FROM ((VISA41717 AS VS)
       LEFT JOIN MASTERCARD_VISA AS MV ON VS.ARN = MV.MICROFILM_NUMBER)
       RIGHT JOIN BIN AS B ON LEFT(Card_Account_Num, 6) = B.INT
  WHERE VISA41717.ARN IS NULL
        OR MASTERCARD_VISA.MICROFILM_NUMBER IS NULL
  ORDER BY VISA41717.ARN;
  </code></pre>
  
  <p>I tried this code but give me an error   </p>
  
  <blockquote>
    <p>JOIN EXPRESSION NOT SUPPORTED</p>
  </blockquote>
  
  <p>Then, I tried this one:</p>
  
  <pre><code>SELECT VISA41717.Fraud_Post_Date,
         VISA41717.Merchant_Name_Raw,
         VISA41717.Merchant_City,
         VISA41717.Merchant_Country,
         VISA41717.Merchant_Category_Code,
         VISA41717.ARN,
         VISA41717.POS_Entry_Mode,
         VISA41717.Fraud_Type,
         VISA41717.Local_Amt,
         VISA41717.Fraud_Amt,
         VISA41717.Purch_Date,
         VISA41717.Currency_Code,
         VISA41717.Cashback_Indicator,
         VISA41717.Card_Account_Num,
         BIN.BANK,
         BIN.COUNTRY,
         LEFT(Card_Account_Num, 6) AS VBIN
  FROM VISA41717,
       BIN
       LEFT JOIN MASTERCARD_VISA ON (VISA41717.ARN = MASTERCARD_VISA.MICROFILM_NUMBER
                                    AND VBIN = B.INT);
  WHERE VISA41717.ARN IS NULL
        OR MASTERCARD_VISA.MICROFILM_NUMBER IS NULL
  ORDER BY VISA41717.ARN;
  </code></pre>
  
  <p>Still there's an error   </p>
  
  <blockquote>
    <p>SYNTAX ERROR IN JOIN OPERATOR</p>
  </blockquote>
  
  <p>I'am trying to create a table from two different tables.   </p>
  
  <p>Thank you in advance.</p>