Join

[#1]

How to show all records which are common in two tables and also records from one table which are not available in another table.

[#2]

Thank you very much:)

[er_mohit]

using where exists function

[makkemik]

please sign as answered in the forum.

thanks.