Need query to pull records from unrelated tables

[aggieval]

I am trying to pull data from two tables that are relatively unrelated (I will be grouping by date). Basically I want to append data from these two tables without running a make Table/Append query. Help Please.

Thanks,
Tracy

 

[hermanlaksko]

Hi Tracy
Your info is a bit short.
It seems that you have a problem, but you can relate on the dates in the tabels, and you do not want to make an make table/append Q. But where is the problem?
Let us know so that we can help

 

[r937]

select stuff from onetable
union all
select morestuff from theothertable
order by thedatecolumn

note that you have to select the same number of columns from each table, and all columns selected have to be datatype compatible

rudy

http://rudy.ca/

 

[aggieval]

Thanks r937. That is exactly what I needed. Thank You, Thank You. Thank You.

Tracy

 

[hermanlaksko]

I think that you owe Rudy a star for this, dont you? B-D