title: ORA-00907: missing right parenthesis 2
body: <p>I am trying to execute this query to get some results in db-visualizer, but I keep getting the following response:</p>
  <p><strong>Response</strong>:</p>
  <blockquote>
  <p>[Error Code: 907, SQL State: 42000]  ORA-00907: missing right parenthesis</p>
  </blockquote>
  <p><strong>Edited</strong> <strong>Query:</strong></p>
  <pre><code>SELECT * FROM (
      SELECT 
      e.*, clt_add_l1, clt_add_l2, clt_city, clt_prst_cd, clt_pszp_cd 
      FROM     Staging.db_&amp;tablename_v._match e,  client.clt_address ca, client.clt_add_usg au 
      WHERE    substr(match_desc,1,2) = '00' 
      and e.clt_ofc_no=au.clt_ofc_no(+) 
      and e.clt_no=au.clt_no(+) 
      and au.clt_ofc_no=ca.clt_ofc_no(+) 
      and au.clt_add_key=ca.clt_add_key(+) 
      and au.clt_add_type(+)='PRI' 
      UNION ALL
      SELECT 
      e.*, clt_add_l1, clt_add_l2, clt_city, clt_prst_cd, clt_pszp_cd 
      FROM     Staging.db_&amp;tablename_v._match e,  staging.clt_address_cp au 
      WHERE    substr(match_desc,1,2) in ('01','02') 
      and e.namadd_no = au.namadd_no(+) 
  ) foo ORDER BY match_desc, seq_no;
  </code></pre>