The following works for me. The Community table has only one entry per community ID so it's fast to look up.
SELECT sCommunityID, (SELECT sTransactionID FROM TransactionList WHERE sCommunityID = Community.sCommunityID ORDER BY sTransactionID Desc Limit 1) as MaxID >From Community WHERE sCommunityID In ('a030600001bFi','a030600004KDy', 'a030600008QhK') Is there any way of just supplying a list of records without having to use another table? I know I can use parameterised queries but I would like to be able to use a single query to get the data, as it feels like it should be possible! Hugh