Thursday, July 6, 2017

Laravel Query Builder - how to format the query using joins

Asked by: user1832141


I know this is a poorly written query. How can I re-write this using the Laravel Query builder?

SELECT tgi.rate, tgi.tax_types_id, tt.name, tt.sales_chart_master_id, tt.purchase_chart_master_id  
FROM tax_group_items tgi, tax_types tt 
WHERE tgi.tax_groups_id = (SELECT tax_groups_id FROM customers WHERE id=2) 
AND tt.id = tgi.tax_types_id 
AND tt.id NOT IN (SELECT tax_types_id FROM item_tax_type_exemptions WHERE item_tax_types_id = (SELECT item_tax_types_id FROM products WHERE id = 1))


Source

No comments:

Post a Comment

Adbox