joining 2 tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hope i explain this clearly. I have 2 tables. TABLE1 contains 250 rows with the following data:
quantit
part I
purchase order numbe
date

TABLE two has the same data plus a column for customer order ID with 150 rows of data

I want a query will return equal rows where quantity, part ID, purchase order number, date match but also the rows where they do not match. Is this possible in one query
 
With SQL or a client side select? A join will do this for you. Then you
can use the inverse (NOT IN) for instance to get the other part.
confused1 said:
I hope i explain this clearly. I have 2 tables. TABLE1 contains 250 rows with the following data:
quantity
part ID
purchase order number
date

TABLE two has the same data plus a column for customer order ID with 150 rows of data.

I want a query will return equal rows where quantity, part ID, purchase
Click to expand...
order number, date match but also the rows where they do not match. Is this
possible in one query?
 
Back
Top