-
SQL question
If I have set of tables in A user that does not exist in B user, and set of tables in B user doesn't exist in A user.
I can do select all of the table in a minus table in A and samething for B, but the question is how can we combine these two into one???
thanks,
-
Can you please explain it again ?
svk
-
(SELECT * FROM tab1
MINUS
SELECT * FROM tab2)
UNION
(SELECT * FROM tab2
MINUS
SELECT * FROM tab1)
Or
(SELECT * FROM tab1
union
SELECT * FROM tab2)
minus
(SELECT * FROM tab1
intersect
SELECT * FROM tab2)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|