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

Reply via email to