title: How to select columns from 2 tables in a Firebird database using zquery?
body: <p>I would like to display on a TDbgrid data from 2 tables on a single database file. I have tried to write sql statements like:</p>
  
  <pre><code>select "Client", "Address", "Balance" from "table1"
  and "Payment" from "table2"
  </code></pre>
  
  <p>But it always shows this error </p>
  
  <pre><code>SQL Error: Dynamic SQL Error DQL Error code = -104 Token Unknown - line 2,
  column1 and.Error -104.Invalid token The SQL: select "Client", "Address", "Balance"
  from "table1"
  and "Payment" from "table2" 
  </code></pre>
  
  <p>I don't know if it is not possible or I just got error on writing the code or is it the TDbgrid I need to modify. I searched for a zeos sql guide but I cannot find one. All I got was this: <a href="http://www.intitec.com/varios/A_ZEOS_basics_tutorial_not_only_for_firebird.pdf" rel="nofollow">http://www.intitec.com/varios/A_ZEOS_basics_tutorial_not_only_for_firebird.pdf</a> but still some of my questions are left unanswered.</p>
  
  <p>I am using firebird database 2.5 and delphi 7.</p>
  
  <p>What SQL code can I use on this?</p>