Oracle Inner/Outer/Full Join
I have two tables table1 and table2
In table1 i have two columns table1.userid and table2.full_name and in
table2 i have two columns table2.userid and table2.ssn
I want records where userid present in both table1 and table2.
Records having userid present in table1 should be ignored if they are
present in table2. If not present than want data from table1 also. Also
want rest of the data from table2.
Should i use inner/outer/full join?
Can you please help me for the same.
No comments:
Post a Comment