Oracle Syntax Help
From: Doug Stone <Doug_Stone_at_compuserve.com>
Date: Wed, 19 Aug 1998 11:36:29 -0700
Message-ID: <OkqEeA6y9GA.52_at_nih2naab.prod2.compuserve.com>
The following SQL contains an outer join.
End SQL ***************
Date: Wed, 19 Aug 1998 11:36:29 -0700
Message-ID: <OkqEeA6y9GA.52_at_nih2naab.prod2.compuserve.com>
The following SQL contains an outer join.
This code works fine with Sybase SQLA, but not with Oracle.
Does anyone know how to re-write this SQL without the "*=" reference?
Begin SQL ***********
SELECT e.emp_id, e.first_name, e.last_name, ea.phone_nbr, u.descr
FROM employee e, emp_address ea
WHERE e.prim_group = :group_id AND
e.prim_skill = :skill_lvl_id AND
e.prim_shift = :shift_id AND
e.emp_id *= ea.emp_id AND
e.emp_id > 0 AND ea.prim_addr = 'T'
ORDER BY e.last_name, e.first_name ASC
End SQL ***************
Thank you,