select f.fid, f.name, count(*) nbMsg
from messages m , forums f
where m.fid = f.fid
group by f.fid, f.name
/
--
Have a nice day
Michel
Olivier Mangez <o.mangez_at_cross-systems.com> a écrit dans le message :
961514203.504390_at_sofia.magic.fr...
> I have 2 tables :
>
> FORUMS contains a primary key FID and another field called NAME
> MESSAGES contains a foreign key FID that is related to FORUMS
>
> How can I get the list of all the forums with the number of messages they
> contain in 1 SQL Query ?
>
> (I use Oracle 8)
>
> I tried the following query but it doesn't work (but works with interbase) :
>
> select f.fid, f.name, (select count(*) from messages m where m.fid = f.fid)
> from forums f order by name
>
>
>
Received on Tue Jun 20 2000 - 00:00:00 CDT
