Return a field in a query to a new field based on a produck SKU

[Caleb]

Hello,
Im trying to write a query that will take a record from an 'Orders' table
and compare the SKU on that record with the SKUs in the 'Product SKU' table.
Once it finds the matching SKU I want it to return the value in the 'Course
Ordered' field for that record and place that value in a new field in my
query called 'Purchased'

Thanks in advance for any help, if you have any questions I'll do my best to
fill you in.

 

[Amy E. Baggott]

If this is just a select query, try joining the orders table to the product
table on the SKU. Then you can select any combination of fields from both
tables and have them show in the query.