what is (+)
hi guys
I am trying to understand this query
SELECT gm.id
,gm.desc
FROM gac_master gm
, gac_mgr_assign glma
, lm_assign_status lmas
WHERE gm.gac_cd = glma.gac_cd(+)
and gm.gac_cd = lmas.gac_cd(+)
and gm.region = 'PARIS'
what does (+) mean.
Doest it mean join?
Is this a proper way to write query?
thanks
I am trying to understand this query
SELECT gm.id
,gm.desc
FROM gac_master gm
, gac_mgr_assign glma
, lm_assign_status lmas
WHERE gm.gac_cd = glma.gac_cd(+)
and gm.gac_cd = lmas.gac_cd(+)
and gm.region = 'PARIS'
what does (+) mean.
Doest it mean join?
Is this a proper way to write query?
thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
it means nothing. It just got copied from the source where you copied this query from. The query wont work until you remove the (+); you'll get a syntax error.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
it's the same as writing the query like this in ANSI syntax
SELECT gm.id, gm.DESC
FROM gac_master gm
LEFT OUTER JOIN gac_mgr_assign glma
ON gm.gac_cd = glma.gac_cd
LEFT OUTER JOIN lm_assign_status lmas
ON gm.gac_cd = lmas.gac_cd
WHERE gm.region = 'PARIS'
SELECT gm.id, gm.DESC
FROM gac_master gm
LEFT OUTER JOIN gac_mgr_assign glma
ON gm.gac_cd = glma.gac_cd
LEFT OUTER JOIN lm_assign_status lmas
ON gm.gac_cd = lmas.gac_cd
WHERE gm.region = 'PARIS'
ASKER
>>>It just got copied from the source where you copied this query from
:-))
i knew it was some kind of join but how do you figure its LEFT OUTER JOIN and not right outer join?
thx all
:-))
i knew it was some kind of join but how do you figure its LEFT OUTER JOIN and not right outer join?
thx all
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
using the actual keyword like 'LEFT OUTER JOIN' is so easy to understand. I am surprised oracle doesnt have that prior to ver 9. understanding (+) is more work, just sayin.
http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/queries006.htm#SQLRF52354