SELECT t1.id
FROM Table1 AS t1
INNER JOIN Table2 AS t2
ON t2.id = t1.id
WHERE t1.location = 'Москва'
AND t2.location = 'Москва'
;

А если вдруг по ID нельзя, то заменить на firstname и lastname.