How do i join two table to get a row count...?

[phanider]

Hi


select D.ID,D.FOOD_ID,F.NAME from DISLIKE_FOOD D Inner join FOOD F on D.FOOD_ID=F.ID and DIS_ID =581
group by D.ID,D.FOOD_ID,F.NAME

this is my inner join query ...i need count of rows....
please help me....

thanks & regards
phani