Postgresql – Query posgresql data joining a table with compound id and multiple criteria for joined table
I'm working in a multi-tenant software to manage inventory of products and I'm having difficulties to create a query to bring products inventory based on quantity criteria. Use case: Bring all products with all their inventory from all warehouses from…