Query to pull results from another query ONLY when it meets conditions

[valkyry]

Ok,
I have a query that pulls data from a master list.

The master list has the parent sku.

I have another query with the totals for the parent sku level as the data is for the components.

So I need the query result to show all records from the master list except when the items match in this another query, then I need it to show the data from this other query.

Did that make sense?

Here's another way.

Query 1 = MasterList
Query 2 = ParentSkuList

Show the MasterList data BUT if the link between the MasterList and the ParentSkuList match (this is a left outer join), then show the data from the ParentSkuList for the matched items, otherwise show the data from the MasterList.


Thanks!

 

[fredk]

I don't fully understand - Please post the fields that are in each query and what is the field that links the two queries.

fred