GroupAggregate (cost=115.00..115.10 rows=5 width=132) |
Group Key: sip.id |
-> Sort (cost=115.00..115.02 rows=5 width=103) |
Sort Key: sip.id |
-> Hash Right Join (cost=25.57..114.95 rows=5 width=103) |
Hash Cond: ((lower((ip.title)::text) = lower((sip.title)::text)) AND (lower(ip.description) = lower(sip.description))) |
-> Seq Scan on tbl_inventory_products ip (cost=0.00..64.16 rows=2016 width=61) |
-> Hash (cost=25.50..25.50 rows=5 width=100) |
-> Seq Scan on tbl_sales_invoice_products sip (cost=0.00..25.50 rows=5 width=100) |
Filter: (sales_invoice_id = 2123) |