Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venkatkrishna
Starting Member
12 Posts |
 Posted - 2007-06-15 : 02:10:52
|
| Hello,I have a query which is written oraclein this they used the Outer join, can any once suggest what could be equivallent sql statement for this.Oracle Statement.select t.area_cd, t.area_desc, f2.last_name mgr_last, t.territory_short_desc, t.team_cd, t.team_desc from atlso.v_da_ff_territory t, atlso.v_da_field_employee f, atlso.v_da_field_employee f2 where t.setid = 'USPFE' and t.active_fg = 'Y' and f.territory_id(+) = t.territory_id and f.setid(+) = t.setid and f.field_active(+) = 'A' and f2.territory_id(+) = t.rpt_lvl1_terr and f2.setid(+) = t.setid and f2.field_active(+) = 'A' and f2.full_name(+) is not nullRegards,Krishna |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Doubt in Joins