SELECT * FROM Practical_Info PI LEFT OUTER JOIN Marketing_Content MC ON PI.Practical_Experience_ID = MC.Practical_Experience_ID