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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-20 : 17:32:20
|
Dermot writes "To whom it concerns,
I have two Tables in my database, The tables have three columns in common. Table A has approx 800 fields and Table B has 3000 fields I want to check that the three column in table A compare to the matching three records in Table B, one of the three columns is a unique identifier.
I was using
strQ="Select * From Supost2 WHERE Supost2.WHEREUSED Not IN (Select TblMaster.CatalogueNO From TblMaster) "
for another query but this will only allow one to one comparision
Any help would be greatly appreciated
Dermot" |
|
|
|
|
|
Comparing Multiple fields