Ver originalSELECT tabla1.*, tabla2.registro as registro2FROM tabla1LEFT JOIN tabla2 ON tabla2.id = tabla1.id