Simple SQL query has me confused

[Solarion]

I'm not feeling very clever today. This has me a bit stumped and likely serious lack of sleep.

I have a simple query and I need the columns added: see pic. How to do this?

 

[Messugga]

How do you mean the columns added?

 

[Solarion]

How do you mean the columns added?

To basically add the number of bookings together for each service type.

 

[shooter_za]

SQL SUM() with group by - w3resource

SQL SUM() with GROUP by: SUM is used with a GROUP BY clause. The GROUP BY clause is required when using an aggregate function along with regular column data, otherwise the result will be a mismatch.

www.w3resource.com

 

[Messugga]

SELECT tblService.id, tblService.type, SUM(tblBooking.number_of_bookings)
FROM ...
GROUP BY tblService.id, tblService.type

 

[¯\_(ツ)_/¯]

GROUP BY

 

[Solarion]

Thanks guys I got it now. One of those moments...

 

[Urist]

Try to learn to write the queries instead of using QBE, It's not difficult once you get the hang of it, and you won't regret it... the possibilities becomes endless.

 

[Thor]

Union

 

[Hamster]

Union

defok!?

 

[Thor]

defok!?

When he said coloums added it sounded like a job for u union.

The picture did not load, now that it has he explained it wrong he don't want it added it he wants it grouped.

 

[_kabal_]

DROP TABLE;

 

[Hamster]

DROP TABLE;

DROP SCHEMA dto;

 

[¯\_(ツ)_/¯]

find / -name "SQL_Trolls" -exec rm -rf {} \;
echo ""

 

[Hamster]

It's all fun and games until the sysadmin rocks up and ruins the fun

 

[Hamish McPanji]

When he said coloums added it sounded like a job for u union.

The picture did not load, now that it has he explained it wrong he don't want it added it he wants it grouped.

Union adds more rows, not coloums?!!

 

[Thor]

Union adds more rows, not coloums?!!

That is correct

 

[Hamster]

UNION ALL, ya'll

 

[¯\_(ツ)_/¯]

1' or '1=1; TRUNCATE TABLE union_names;

 

[Hamster]

mv /var/lib/mysql/* /dev/null