Query problem

[Anon]

These r my tables

Tab A

A_catid
1
2


Tab B (child of A)

B_catid A_catid
1 1
2 1
3 1
4 1

5 2
6 2

Tab C (child of 😎

C_rowid    B_catid
1          1 
2          1
3          1 
4          2




If user selects an item from Tab_A I want that the corresponding rows from Tab_B be displayed along with the count of child rows
that each record of Tab_B has in Tab_C

In this case when user selects 1 from Tab_A
the output should be given as follows:


1 -- 3
2 -- 1
3 -- 0
4 -- 0


HELP !

[[deleted]]

A relates to B and B relates to C.
But C does not relate to A.

You'll have to do several queries, because a JOIN would in inappropriate.

SELECT * FROM table_B WHERE A_catid = $a_catid;

SELECT count(*) from table_c WHERE B_catid = $b_cartid;

[neville]

Currently my query shows
1 -- 3
2 -- 1

Coz '1' in Tab_B has got 3 recs in Tab_C and so on. It is not showing the recs from Tab_B that have no records in Tab_C
ie: like so:

1 -- 3
2 -- 1
3 -- 0
4 -- 0

Besides I need to show the count(from Tab_C) and the Category (from Tab_😎 in one row.

How do I manage that with 2 result sets ?

Thanks.