Access Query Design

  • Thread starter Thread starter rohanchristie
  • Start date Start date
R

rohanchristie

How do I design a query to show the items that do not match versus the
items that matched, when querying two files using a primary key? I
need the outliers rather than the matches.
 
Make a Left or Outer Join (That's all the ones from Table A and matching
from Table B. This will create null rows in Table B. Then add all the
records for Table A where the Primary Key in Table B Is Null. There is a
query wizard that will do this for you. Select Query then New and choose the
wizard.
 
Back
Top