list of unmatched countries from multiple tables using sql server

[teja murali]

hi Experts, im new to sqlserver,my task is...i had a two country tables(t_country and p_country).i want to list the countries which are not in p_country. thnks in advance

[Mycroft Holmes]

Select * from tCountry where country not in (Select country from pcountry)

[i i i]

i will not talk about Normalization here and will post only regarding your question only try to use "NOT IN " in query select ID from T_country where id not in (select ID from P_country) if you dont have any keys then use the common fields exists in both the tables like in your case you can use Country Name but will not recommend you makes query so slow try to use any numeric fields and you can also use not equal join

Best Of Regards, SOFTDEV Sad like books with torn pages, sad like unfinished stories ...