joining queries

  • Thread starter Thread starter Faisal
  • Start date Start date
F

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
 
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
 
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
 
Back
Top