problem with nested selects

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