select record from temporary table ??

Question

 

hii friends i have a first temporary table in which some column

like  : client id, client name, details 

 

and another second table : city

 

in which have column clientid, city name,

 

and want select both table with inner join

 

first table it have 200 record and both tables some  client id same

 

i want select those record from first table that client id it not have in second table  

 

i want remaining client details which client id not common in second table 

Answer 1

check Our recommended articles section, might helps