Advertisement
Guest User

Untitled

a guest
Jul 25th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. CREATE TABLE a (
  2. id INT
  3. );
  4.  
  5. CREATE TABLE b (
  6. id INT,
  7. a_id INT,
  8. sum INT
  9. );
  10.  
  11. INSERT INTO a SET id=1;
  12. INSERT INTO b SET id=1, a_id=1, sum=2;
  13. INSERT INTO b SET id=2, a_id=1, sum=3;
  14.  
  15. id -- count(*) -- sum(sum)
  16. 1 -- 2 -- 5
  17.  
  18. SELECT a.id, tmp.*
  19. FROM a
  20. LEFT JOIN (SELECT b.a_id, COUNT(b.a_id) as `count`, SUM(`sum`) as summa
  21. FROM b
  22. GROUP BY b.a_id
  23. ) tmp
  24. ON tmp.a_id = a.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement