joining two like tables 1

[DrHabi]

How can I create a view to join two like tables into one. Both tables have the same fields and I would like to create a view to join them together. One is for current sales and the other is for posted sales and when I select a date range I want to be able to get data from both tables and add the like fields together.
Thanks

 

[roccorocks]

Are you looking to use a Union?

table1

union all

table2

The union will give you all rows from each table, using only one set of columns. Is this what you are after? A join will give you possibly ALL of the columns from each table, even though they are the same column names (of course proper syntax would need to be used for the second table columns). If you need help putting the union together, let us know.

thanks,

Rocco

 

[DrHabi]

that is what I was looking for.