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

is it a web form or windows form? Did you apply the multiline paramenter to the textbox?

In web form click on the textmode property and select multiline. Or in windows form change multiline from false to true.