Devendra  Kumar

Devendra Kumar

  • NA
  • 517
  • 244.6k

select record from temporary table ??

Nov 26 2016 4:22 AM
 
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 

Answers (2)