Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2010-09-25 : 06:55:15
|
| Hello I have 4 tablestable1, table2 , table3, table4table1 contains filternoTable2 contains filterno,courseno, offernoTable3 contains Courseno,coursedetail,coursestatustable4 contains offerno,offertype where Filterno='2'I wantfilterno,courseno,coursedetail,offerno,offertypeplease help me outRegards,ASIF |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-09-25 : 07:23:40
|
select ...from table1 as t1join table2 as t2 on t2.filterno = t1.filternojoin table3 as t3 on t3.courseno = t2.coursenojoin table4 as t4 on t4.offerno = t2.offernowhere filterno='2'
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
how to join 4 tables