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 |
|
TajKazi
Posting Yak Master
101 Posts |
 Posted - 2014-11-13 : 04:55:28
|
| select eue.PERSONID, eue.EID, eue.NAME_COMPLETE, eue. eue.EMAIL_ADDRESS_OFFICE as EMAIL from HAIL_ESS_USERS_EXTENDED_V eue where eue.PERSONID = p_person_id) eue join (select * from HAIL_ESS_ROLE_MAP where ROLE_ID in (select ID from HAIL_ESS_ROLES where upper(ROLE_NAME) like upper('Rewards and Recognition%')))b on eue.PERSONID=b.PERSON_ID(+); any body tell me meaning of (+) i have to migrate this query from oracle to slq server 2008 |
|
|
mmkrishna1919
Yak Posting Veteran
95 Posts |
Posted - 2014-11-13 : 08:10:02
|
| The equivalent key word is RIGHT OUTER JOIN.M.MURALI kRISHNA |
 |
|
|
TajKazi
Posting Yak Master
101 Posts |
Posted - 2014-11-13 : 22:58:02
|
| right answer i found that LEFT OUTER JOIN |
|
|
|
|
|
|
migration oracle to sql server