|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
June 24th, 2004, 04:28 AM
|
|||
|
|||
How to retrieve mismatched records with MS Access Query
Hi, does anyone know how to retrieve mistmatched records across 2 tables.
To clarify, I have table A with 1175 records and Table B with 894 records. The records from table A match exactly some the records in table B. I want to create another table with the extra 281 records from Table A which does not match that of Table B. I have tried the query with Select where fields_1.a<>fields_2.b AND fields_2.a<>fields_2.b etc but that doesn't seem to work. *desparate* Last edited by knockingknees : June 24th, 2004 at 12:29 PM. Reason: Let me explain more clearly
|
|
#3
June 26th, 2004, 06:22 AM
|
||||
|
||||
|
Code:
select tableA.key
, tableA.col1
, tableA.col2
into tableC
from tableA
left outer
join tableB
on tableA.key
= tableB.key
where tableB.key is null
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > How to retrieve mismatched records with MS Access Query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
