Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT c.id as company_id, SUM(ct.amount) as total_billed, count(l.id) as load_count
- FROM tbl_companies c
- LEFT JOIN tbl_company_transactions ct ON c.id = ct.company_id
- LEFT JOIN tbl_loads l ON c.id = l.company_id
- GROUP BY c.id;
Add Comment
Please, Sign In to add comment