title: Paradox DB SQL Multiple JOINS
body: <p>I'm working on a legacy VB6 project and I need to make a JOIN call like this:</p>
  
  <pre><code>SELECT C.Cnum, C.RealDate, M.Name, R.Price, R.Qnt, R.RealPrice, R.QntP, R.QntR, M.Name
  FROM "CHECK" C 
  LEFT JOIN "RCHECK" R ON C.Cnum = R.Cnum 
  LEFT JOIN "PCHECK" P ON C.Cnum = P.Cnum 
  LEFT JOIN "MONEY" M ON P.Curency = M.Sifr 
  LEFT JOIN "MENU" MN ON R.Sifr = MN.Sifr 
  WHERE C.Cnum &gt; 0 ORDER BY C.Cnum
  </code></pre>
  
  <p>I use <code>"Driver={Microsoft Paradox Driver (*.db )};DriverID=538"</code> as a part of connection string but it seems it doesn't support more than one join! Which is weird.</p>
  
  <p>Any ideas how to solve/workaround it?</p>
  
  <p>And yes, when I run this query in Borland Database Desktop, it works fine.</p>
  
  <p>Update 1:</p>
  
  <p>My VB Code:</p>
  
  <pre><code>Dim Conn As New ADODB.Connection
  Dim sConnStr As String
  Dim sQuery As String
  
  sConnStr = "Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;CollatingSequence=ASCII;DBQ=C:\DBTOFTP\BUFF;DefaultDir=C:\DBTOFTP\BUFF;PWD=SOMEPASS;"
  
  sQuery = "SELECT C.Cnum, C.RealDate, M.Name, R.Price, R.Qnt, R.RealPrice, R.QntP, R.QntR, M.Name " &amp; _
      "FROM ""CHECK"" C " &amp; _
      "LEFT JOIN ""RCHECK"" R ON C.Cnum = R.Cnum " &amp; _
      "LEFT JOIN ""PCHECK"" P ON C.Cnum = P.Cnum " &amp; _
      "LEFT JOIN ""MONEY"" M ON P.Curency = M.Sifr " &amp; _
      "LEFT JOIN ""MENU"" MN ON R.Sifr = MN.Sifr " &amp; _
      "WHERE C.Cnum &gt; 0 " &amp; _
      "ORDER BY C.Cnum"
  
  Conn.ConnectionString = sConnStr
  Conn.Open
  </code></pre>