Click here to Skip to main content
15,903,736 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have 7 table they all have candidateId as common field. The condition of join is that if the table contains data then it will join other wise not. My first table contain data but others may or may not be contained data . Now how can i join them?

other 6 table are jenerated by subqueries.
Posted

Using SQL Join[^].

You may search Google for more 'Join' examples and understand the concept well.
 
Share this answer
 
Comments
ParthaDinda 25-Apr-11 6:15am    
hi ankur,
Actually i am doing advance search in my application where some field my contain search words some may not. and all filed search in different tabel.can you tell me how to join these searched table ? according to condition i have innerjoin them at last. but if some return table is null how can i join them?
Ankur\m/ 25-Apr-11 6:20am    
You are probably looking for Coalesce function - http://msdn.microsoft.com/en-us/library/ms190349.aspx
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900