Inner join or Outer Join

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need immediate help. I have a table with 25000 records (table
A) and another table that has 6000 records (table B). I need to do the
following:

If record # 2 from table B is in table A do not display in query.

I need to get ONLY the remaining records from table A when compared to table
B. I know it's got to do with something with equajoins.
 
Use the query wizard to create an Unmatch records query

SELECT TableName.*
FROM TableName LEFT JOIN TableName2 ON TableName.FieldName =
TableName2.FieldName
WHERE TableName2.FieldName Is Null
 
Select *
From TableA Left Outer Join TableB on TableA.ID = TableB.ID
Click to expand...
Where TableB.ID Is Null

This query will give you all the records that are in TableA but not
TableB.

Hope that helps!
 
Take the SQL statement I gave you and paste it into a new query. Click
View, SQL View and paste the statement into the window.
 
Table A on the left and Table B on the right. Would the Arrow be pointing to
the left or to the right?
 
Back
Top