I need to do a join with a count...but for some reason I canıt figure out how to do it using MySQL. Iım hoping that this pseudo code can help you give me an answer:
> select > > f.count(*), > s.name > > from > > first f, second s > > where > > f.id = s.id How do I get a sql result like: Count Name --------------------------- 12343 Test Iıve attempting adding the group by function as documented, but MySQL has some demands I donıt understand. Thank you in advance! Mark