How do I get all records to appear?

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

Guest

I am merging two tables in a query. Table A contains all products and Table
B contains only products with a warranty. I want a listing of all products
regardless of whether it is in the warranty table or not.

Thank you for your help,
Carla
 
Try a UNION Query. You have to use the SQL editor for this.

SELECT table1.field1, table1.field2, table1.field3 FROM table1 UNION SELECT
table2.field1, table2.field2, table2.field3 FROM table2;

Make sure the corresponding colums in each table have the same name.

Hope this helps!

Brian
 
Use a left join query that includes all the records From products table, with
tha matching records from warranty
e.g

SELECT products.*, warranty.*
FROM products LEFT JOIN warranty ON products.FieldJoin =
warranty.Last_FieldJoin
 
Back
Top