SELECT * FROM a INNER JOIN b ON a.id = b.id;