BoarderLine Posted November 10, 2011 Share Posted November 10, 2011 Hi. Can someone please point me in the right direction with this. I have the following tables:- table: options | id | sta | fin |valID| |-----|----- |----- |------| | 3 | 984 | 984 | 1 | | 7 | 165 | 685 | 1 | | 5 | 233 | 876 | 1 | table: values | id | col | |-----| -------| | 1 | harry | I am using the following query to attempt to get a joined result set against the key (id), and the MIN(fin) ROW. SELECT values.col, options.id, options.sta, MIN(options.fin) AS fin FROM values JOIN options ON options.valID = values.id GROUP BY options.valID, options.fin ORDER BY col I would like this to result: | col | id | sta | fin | | ----- |----|----- |----- | |harry| 7 | 165 | 685 | However I get the result: | col | id | sta | fin | | ----- |----|----- |----- | |harry| 5 | 233 | 685 | How can obtain the result values for the entire row which contains MIN(fin). Hope this makes sense to someone? Many Thanks. Link to comment https://forums.phpfreaks.com/topic/250818-not-sure-how-to-get-min-on-joined-query/ Share on other sites More sharing options...
fenway Posted November 10, 2011 Share Posted November 10, 2011 How come sta isn't 165? Link to comment https://forums.phpfreaks.com/topic/250818-not-sure-how-to-get-min-on-joined-query/#findComment-1287065 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.