I have 3 tables with some values.Some of the ID's are present in Table A,Some in Table B and other in Table C.I just want to know,what are the values present in one table are not present in another table.
ORDER BY A.ID,B.ID,C.ID
It is easy only when you have understanding of JOINS concept in SQL.
SELECT A.ID,B.ID,C.ID
FROM A FULL OUTER JOIN B ON A.ID=B.ID
FULL OUTER JOIN C ON A.ID=C.ID OR B.ID=C.ID
It is easy only when you have understanding of JOINS concept in SQL.
No comments:
Post a Comment