sql query to count column values from multiple tables and su

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 SUM,MIN,MAX..) in sql .

try

select t1.username,SUM(1.salary)

from table1 t1 join table2 t2 on t1.username=t2.username

group by t.usename

hop will help.

Yadlapalli Srikanth12y ago

SELECT table1.UserName,COUNT(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 Shanker12y ago

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

Jignesh Trivedi12y ago

hi,

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