Me Again, need help with Count/Distinct

MadRhino

ok... I have 2 tables that I need to gather info from:

Table 1= inventory (inventory_id, community_id, etc.)
Table 2 = communities ( community_id, community_name, etc..)

What I am trying to do is get a total of inventory fro each community.

I managed to run a query on only table 1 with this:

select distinct community_id, count(community_id) as count from inventory group by community_id

Which produced a result like below, which is correct.

1 (1)
2 (2)
3 (3)
4 (18)
5 (1)

I am trying to accomplish the samething but this time I need to select ALL data from
inventory(table 1) and communities(table 2) so I can display the data correctly.

Any ideas?

Thanks!

djjjozsi

How about this.

SELECT communities.community_name, communities.community_id, Count(inventory.inventory_id) AS CountOfinventory_id
FROM inventory INNER JOIN communities ON inventory.community_id = communities.community_id
GROUP BY communities.community_name, communities.community_id;

MadRhino;10890421 wrote:
ok... I have 2 tables that I need to gather info from:

Table 1= inventory (inventory_id, community_id, etc.)
Table 2 = communities ( community_id, community_name, etc..)

What I am trying to do is get a total of inventory fro each community.

I managed to run a query on only table 1 with this:

select distinct community_id, count(community_id) as count from inventory group by community_id

Which produced a result like below, which is correct.

1 (1)
2 (2)
3 (3)
4 (18)
5 (1)

I am trying to accomplish the samething but this time I need to select ALL data from
inventory(table 1) and communities(table 2) so I can display the data correctly.

Any ideas?

Thanks!

G

MadRhino

Man.. that was quick! You guys and gals are amazing in this forum!

I'll try it out and report back! Thanks a million!