Slow Inner Joins

[John Wall]

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_number); My table holds scan events, each card has a part number, and kan number. Each scan is a row, and the table holds several of the same part/card/locations, but at different dates. I need to select the most current row, one from each card, to get the current information of where they are in the plant. Fields in kanban_card part - text kan_number - int location - int datestamp - date id - autonumber