Multiple Count from multiple tables

Question

I have two tables and i am trying to get count from both tables. Means count from first table then count from 2nd table and result should look like this.

Count(users.name)   Count(users_types)
        5                    8

But my query brings this result

Count(users.name)   Count(users_types)
        8                    8

Here is my query

select count(users.users),
count(users_types.users_types)
form users , users_types

How can i get correct result?

Sudhir Bastakoti · Accepted Answer · 2012-04-30 11:55:44Z

1

try:


select
(select count(users.users) from users),
(select count(users_types.users_types) form users_types)

answered Apr 30, 2012 at 11:55

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Nightwolf Over a year ago

This works fine, but slows down the query significantly when the tables contains large amount of data. The original question seems to want it done without the speed issue.

Sudhir Bastakoti Over a year ago

well, nothing as such is mentioned in the question..!

Nightwolf Over a year ago

Nothing wrong with your answer, but why not add the alternative answer that allows for faster results.

Addicted · Accepted Answer · 2012-04-30 12:03:47Z

1

select (select count(*) cnt1 from table1),
 (select count(*) cnt2 from table2)

answered Apr 30, 2012 at 12:03

Addicted

1,7042 gold badges16 silver badges24 bronze badges

Comments

Muhammad Raheel · Accepted Answer · 2012-04-30 12:10:10Z

0

Use a sub query like this

select
  count(users.users)    Users,
  (select
     count(users_types.users_types)
   from teams)    UsersTypes
from users

answered Apr 30, 2012 at 12:10

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

Collectives™ on Stack Overflow

Multiple Count from multiple tables

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related