samona Posted January 21, 2011 Share Posted January 21, 2011 Hi, I was wondering if anyone can help me convert this query to just one regular query. $query = 'Select * From Volume as vol WHERE vol.Volume_ID = (Select Max(Volume_ID) From Volume Where Type = vol.Type and User = vol.User) ORDER BY vol.Type, vol.User'; Link to comment https://forums.phpfreaks.com/topic/225223-convert-subquery-to-standard-query/ Share on other sites More sharing options...
mikosiko Posted January 21, 2011 Share Posted January 21, 2011 modify it to a regular query imply only use GROUP BY if that not solve what you want... post examples of your data and the desired output Link to comment https://forums.phpfreaks.com/topic/225223-convert-subquery-to-standard-query/#findComment-1163188 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.