Skip to main content
Suggested answer

Apply filters to multiple tables together in a query

editSubscribe (0) ShareShare
ReportReport
Posted on by 119
Hi everyone, 

I have a query made with the following tables; Price List Header, Price List LineCustomer and Item. I want to filter customer and item on the basis of unit price. Currently, the query outputs same combination of Item and Customer with different unit price. However, I want to show unique combination of Item and Customer. For the records having different unit prices for same Item-Customer combination, I want to filter such record based on lowest unit price. 

For example:
Right now, it outputs:  
CustomerItemUnit Price
Customer1Item14
Customer1Item15
Customer2Item16
 
The result I want:
CustomerItemUnit Price
Customer1Item14
Customer2Item16


I'd appreciate any help or suggestion. Thank you in advance. 
Categories: