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 |
|
rastham
Starting Member
1 Post |
 Posted - 2006-02-15 : 10:09:42
|
| hi.... i am a new user of this forum... i wud lik to knw which is the best method for comparing rows of two seperate table... thanks in advance... |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-02-15 : 23:18:17
|
| Hi,Do both the tables have same structure?Are you trying to find out the matching rows in both the tables?you can use..Select <column list> from table1join table2on table1.pk = table2.pkwhere table.col1= table2.col2If you could explain your requirments it would be better in helping you finding a solution.. |
 |
|
|
a_r_satish
Yak Posting Veteran
84 Posts |
Posted - 2006-02-15 : 23:52:29
|
May i know ur exact requirement... There are many ways for doing so.quote:
Originally posted by rastham
hi.... i am a new user of this forum... i wud lik to knw which is the best method for comparing rows of two seperate table... thanks in advance...
Regards,satish.r |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Better option