i'm partial to parulprabu showing me how to make query 2 work using this join.

join location_history loch on loch.date_assigned = lh.Last_Date_Assigned and loch.iphone_id=lh.iphone_id.

really appreciate.

Thanks to you both for your replies. I'll look to see if there's a performance benefit of one over the other.