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'; Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.