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 |
|
subhaoviya
Posting Yak Master
135 Posts |
 Posted - 2010-10-26 : 08:54:09
|
| Hi, am having 5 tables liketable1 (c1-PK)table2(C1 FK)(c11 PK)table3(C1 FK)table4 (c11 PK)and table5.(c11 PK)table1 is main table. its PK field is forgeign key for table2 and table3.table2 is for recording successful records. so if it has entry table3 or table4 have records based on conditionall the table has some specific fields to be considered.i need to get the records by reference table1 PK field value and place the values to destination tablehow to handle this?thankssubha |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-10-26 : 11:54:21
|
| http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
subhaoviya
Posting Yak Master
135 Posts |
Posted - 2010-10-27 : 00:23:58
|
| I have used the left out join and did that.thanks for the support friend. |
|
|
|
|
|
|
Quering more than a table