ORA-907 missing right parenthesis when using AS keyword : <p>I get a ORA-907 with the following sql statement. It looks like that there's a problem with using the AS keyword.
When I remove the AS keyword and use complete tablenames in my statement it works as expected.</p>

<p>Is that a known issue with oracle? It's running on an 11g, when more details are needed I've to talk to my admin.
I've found some older hints which state that there was a bug, in versions &lt; 11.</p>

<pre><code>SELECT easbwaredgs_t.id, easbwaredgs_t.fk_easbware_id, easbwaredgs_t.mandant, easbwaredgs_t.reg_code_mc,   
       easbwaredgs_t.hazard_code_ident, easbwaredgs_t.add_hazard_code, easbwaredgs_t.haz_code_version,   
       easbwaredgs_t.undg_number, easbwaredgs_t.ship_flashpoint, easbwaredgs_t.flashpoint_type,   
       easbwaredgs_t.cont_dopc, easbwaredgs_t.cont_dop, easbwaredgs_t.cont_phone, easbwaredgs_t.verpack_grp_mc,   
       easbwaredgs_t.ems_nr, easbwaredgs_t.trem_card_nr, easbwaredgs_t.secondimo, easbwaredgs_t.thirdimo,
       (
         SELECT COUNT(*)
         FROM easbwaredgs_t AS k
           LEFT OUTER JOIN easbdgstn_t AS p ON k.id = p.fk_easbwaredgsid
         WHERE k.mandant = '001'
           AND k.fk_easbware_id = 1
           AND p.type_mc = 'TRANSPORT_DGS_LIM_QUANT'
       ) AS cc_is_limited_quantities
FROM easbwaredgs_t
WHERE easbwaredgs_t.mandant = '001'
  AND easbwaredgs_t.fk_easbware_id = 1
</code></pre>
