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 |
|
dtong004
Constraint Violating Yak Guru
281 Posts |
 Posted - 2001-06-12 : 11:50:48
|
| I have two table sits in different database. The two table almost identitcal except one of the table have a few records less than table two. The 2 tables have one unique column. I need to find the missing records in Table1. I tried use subquery to do the work. Unfortunately, It take forever for sql to return. Both tables have about 3 million records and the difference only about 100 or so. Does anyone have better idea other than subquery? I tried to ask sqlteam before. ThanksDaniel |
|
|
|
|
|
compare records in two tables