Combining these two SQL statements into one

Question

What would be the best way to combine these two SQL statements into one? I tried to use the union, but it seems I’m not going anywhere.

select id as id from likes where type=1; select sum(votes) as votes from likes where parent=id; 

Here is the likes table:

 id type parent country votes 1 1 0 US 0 2 2 1 US 6 // This + 19 3 1 US 3 // This 3 3 2 US 3 7 3 2 US 3 4 10 3 US 1 5 10 3 US 1 6 10 3 US 1 10 10 7 US 1 9 10 7 US 1 8 10 7 US 1 20 10 19 US 1 21 10 19 US 1 22 10 19 US 1 

This is the result that I am trying to achieve:

 id | votes --------------- 1 | 9 

Answer 1

Try the following:

 SELECT l1.id, SUM(l2.votes) AS Totalvotes FROM likes AS l1 INNER JOIN likes AS l2 ON l1.id = l2.parent WHERE l1.type = 1 GROUP BY l1.id; 

Look here:

• SQL Fiddle Demo

This will give you:

 | ID | TOTALVOTES | ------------------- | 1 | 9 | 

Answer 2

 SELECT SUM(votes) AS votes FROM likes WHERE parent IN (SELECT id FROM likes WHERE type=1) 

NTN

Answer 3

This should solve your problem, I believe:

 SELECT parent AS id, SUM(votes) AS votes FROM likes WHERE parent IN (SELECT id FROM likes WHERE type = 1) GROUP BY parent; 

Answer 4

You can try this

 select id,sum(votes) as votes from likes where type=1 and parent=id; 

Hope this helps