sql query to count column values from multiple tables and su

Question

i need a query to count column values from multiple tables and sum up... i got username column in three tables.. i need to count the values and sum...

Anupam Singh · Answer

Hi Prathiban You can use sql join operator for this. I have used just inner join you can use as per you need. with group by you can simply use any Aggregate function(e.g SUMMINMAX..) in sql . try select t1.usernameSUM(1.salary) from table1 t1 join table2 t2 on t1.username=t2.username group by t.usename hop will help.

Yadlapalli Srikanth · Answer

SELECT table1.UserNameCOUNT(table1.UserId) AS NumberOfUsers FROM table1 Inner JOIN table2 ON table1.UserId=table2.UserId GROUP BY UserId; If this post helps you mark it as answer Thanks

Abhay Shanker · Answer

Please explain in detail your requirement and if possible kindly share the sql table structure with us

Jignesh Trivedi · Answer

hi I cannot get your question. Can you provide more information with good end to end example.