title: Selecting multiple columns from multiple tables
body: <p>I've constructed the flowing SQL for my netezza db:</p>
  
  <pre><code>select t.TRADE_OID, t.TRADE_ID, t.TRADE_VERSION, t.TRADE_SOURCE_SYSTEM, tl.LINK_PARENT_ID, 
  tl.LINK_PARENT_VERSION, tc.CHARGE_AMOUNT FROM EQ_MO_TRADE (NOLOCK) t, EQ_MO_TRADE_CHARGE (NOLOCK) tc, EQ_MO_TRADE_LINKAGE (NOLOCK) tl 
  WHERE t.Last_update_time &gt;= '2013-01-09 00:00:00' 
  AND t.last_update_time &lt; '2013-01-10 00:00:00' 
  AND t.TRADE_OID = tl.TRADE_OID
  AND t.TRADE_OID = tc.TRADE_OID
  AND tc.CHARGE_NAME = 'Commission'
  </code></pre>
  
  <p>However I'm given the general error:</p>
  
  <pre><code> [SELECT - 0 row(s), 0.000 secs]  [Error Code: 1100, SQL State: HY000]  ERROR:  'select 
  
  t.TRADE_OID, t.TRADE_ID, t.TRADE_VERSION, t.TRADE_SOURCE_SYSTEM, tl.LINK_PARENT_ID, tl.LINK_PARENT_VERSION, tc.CHARGE_AMOUNT FROM EQ_MO_TRADE (NOLOCK) t, EQ_MO_TRADE_CHARGE (NOLOCK) tc, EQ_MO_TRADE_LINKAGE (NOLOCK) tl 
  WHERE t.Last_update_time &gt;= '2013-01-09 00:00:00' 
  AND t.last_update_time &lt; '2013-01-10 00:00:00' 
  AND t.TRADE_OID = tl.TRADE_OID
  AND t.TRADE_OID = tc.TRADE_OID
  AND tc.CHARGE_NAME = 'Commission' limit 1000'
  error                                                                                                                                                         
  
  ^ found "(" (at char 150) expecting `EXCEPT' or `FOR' or `INTERSECT' or `ORDER
  </code></pre>
  
  <p>Character 150 is between these two:</p>
  
  <p>Trade and (NOLOCK)</p>
  
  <p>My syntax seems correct but DBVisualiser won't run the query.</p>