Phpmyadmin

[repara2]

Código MySQL:

SELECT
  S.*,
  L.*
FROM servicio S
  LEFT JOIN lineas S
    ON (S.idlinea = L.idlinea)
    WHERE S.iddestino = 'xxxxxxx';