[eluser]Sarfaraz Momin[/eluser]
Hi, here I am again wanting assistance from the best community. The issue is related to a mysql query. I want to achieve a task using one query and joins. So here it is.
Task : A Photo Album.
Tables : Groups, Users, Albums, Photos.
Requirement : Want to list albums with the following information.
Album title - count of pics in the album - user who created that album - date and name of the last person posting a photo to that album.
Album has reference for User and Group.
Photo has reference for Album.
I hope it makes sense.
Any queries or clarification please reply.