Merge Tables based on Date

[Homer J]

I'm have a numbers of tables that contain the number of quotes and sales by date. The tables are split by product

So for example: table a/Table b/Table c all contain...

Date/Quotes/Sales
20.02.07/50/20
21.02.07/55/15

I am trying to create a new table joining these 3 tables together by date
Date/Table a:Quotes/Table b:Quotes/Table c:Quotes and so on

I have created a separate date table and have joined all 3 tables to the date table but I end up with a hugh amount of duplicates.

How do I get rid of the Duplicates?

 

[llkhoutx]

Use Union queries on the three tables rather than Joins.

Joining tables on keys which are not unique primary keys will create duplicates.

Table primary keys and Relationships with cascading updates and cascading deletes are bvery important in table design.