I have three table
client table has following field
c_name c_amount c_date
tcs 1000 2012/30/01
cts 2000 2012/25/01
hcl 3000 2012/25/01
trainer table has following field
t_name t_amount t_date
tcs 500 2012/30/01
cts 100 2012/25/02
hcl 300 2012/25/02
expense table has following field
e_name e_amount e_date
travelling 5000 2012/30/01
food 1000 2012/25/01
others 1500 2012/25/02
Above three table has no common column or no primary key foreign key relation ship
how to get join three tables
i want month wise result like below
c_name c_amount c_date t_name t_amount t_date e_name e_amount e_date
tcs 1000 2012/30/01 tcs 500 2012/30/01 travelling 5000 2012/30/01
food 1000 2012/25/01
cts 2000 2012/25/01
hcl 3000 2012/25/01
Loading
MohamedPosted Oct 3, 2012, 8:07 PM
Ganesh MPosted Sep 28, 2012, 6:18 AM
solution not exist in this link
Any other suggestion?
RanjithKumar chiguruvadaPosted Sep 28, 2012, 5:45 AM
Refer the following URL:
http://social.msdn.microsoft.com/forums/en-US/sqlexpress/thread/70313a92-26d3-4e14-8404-be068ce1fbbf/