joining queries

[Faisal]

i have a query with a field called"product1"
i have a another query with a field called "product2"
now i want to make a query by using these two queries
in my new query only one filed should see that "product1"
continew with "product2"
any tips pls

 

[mscertified]

I dont really understand what you need but try this:
SELECT Q1.*, Q2.* FROM Query1 As Q1, Query2 As Q2 WHERE Q.Product1 =
Q2.Product2

-Dorian

 

[Faisal]

dear sir,

soryy for your confusion over my question actually i want to merge two field
of two different quries as one query ,but i got solution form other source by
using union query

thnank you for you kind attention over my question
regrds
faisal