Try...
SELECT location FROM kanban_cards a
WHERE id IN(SELECT Max(id) FROM kanban_cards b
WHERE a.part = b.part
AND a.kan_number = b.kan_number)
ORDER BY part, kan_number;
Eddy
On Fri, 2004-11-05 at 14:27, John Wall wrote:
> I am using 4.1 with inner joins, and my
I am using 4.1 with inner joins, and my
query is taking about 9.4 seconds to excute now. I used looping functions before
in php, but I wanted one sql to do it all
SELECT location FROM kanban_cards WHERE
id IN(SELECT Max(id) FROM kanban_cards GROUP BY part, kan_number ORDER BY part,
kan_numb