Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
joining a mystery
mysql> select e.name, count(p.event), e.date, e.events, count(c.id) from events e left join pictures p on p.event=e.events left join comments c on c.picture=p.id group by e.events order by e.date desc; +---------------------------------+----------------+------------+--------+-------------+ |...
