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 |
|
mageshks
Yak Posting Veteran
59 Posts |
 Posted - 2008-09-23 : 12:01:10
|
| Hi All, Is there a way to track the records in the tables that are used in the join?.For example my join looks like the following , select t1.id,t2.name,t2.address from table1 t1 join table2 t2 on t1.id = t2.id I want to update the row in the table where id is taken and also want to track the row in the table2 where name and address are taken.Hope you understand my query.I just want to keep track what are all the records selected for my output from which table..Thanks in advance.. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-23 : 12:57:23
|
| didnt get what you're looking. can you elaborate please? what do you mean by 'track'? |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-09-24 : 01:15:34
|
post some sample data and show us what do you want
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Tracking the records - is there a way?