SELECT * FROM Practical_Info PI LEFT OUTER JOIN Marketing_Content MC ON PI.Practical_Experience_ID = MC.Practical_Experience_ID
A friend of mine, Rick Playko, passed this to me the other day. It's a bit old, but still a good reminder.
http://www-128.ibm.com/developerworks/rational/library/4032.html
Jon