[sqlite] Rewriting a query

[Hugh Gibson]

I have this query:

  SELECT sCommunityID, max(sTransactionID)
  FROM TransactionList 
  WHERE sCommunityID in ('a030600001bFi','a030600004KDy', 'a030600008QhK')
  GROUP BY sCommunityID
                
There is an index on (sCommunityID, sTransactionID)

This forces a table scan (perhaps improved in 3.2.6). 

I can use a LIMIT 1 clause like this, but only with one community ID:

  SELECT sCommunityID, sTransactionID
  FROM TransactionList 
  WHERE sCommunityID  = 'a030600001bFi'
  ORDER BY sTransactionID Desc LIMIT 1

Is there a way of getting the latter to work with multiple sCommunityIDs?

Hugh