Creating a table from 2 different queries

[Jaz]

I have 2 queries that provide the following information:

Query 1
Vendor ID
Ship Qty

Query 2
Vendor ID
RejectQty

Is there a way to run these 2 queries and make 1 table with the following
information?

Vendor ID Ship Qty Reject Qty


Thanks,
Jasper

 

[Douglas J. Steele]

Sure. Create a 3rd query that joins them together (as though they were
tables), and use that query.

The SQL would look something like:

SELECT Query1.VendorID, Query1.ShipQty, Query2.RejectQty
FROM Query1 INNER JOIN Query2
ON Query1.VendorID = Query2.VendorID

 

[Jaz]

Perfect!

One more question: If this 3rd query uses the other queries to run, does it
actually run the 2 queries first?

So if I make a change on any of the first 2 queries, will it affect the 3rd
query?

Thanks,
Jasper

 

[Douglas J. Steele]

Yes, if you make changes to either of the first 2 queries, those changes
will apply to the 3rd query as well.