4 Replies Latest reply: Dec 12, 2014 4:38 AM by sujeet Singh RSS

    Difference between left keep and left join

      Hi everyone,


      I am looking at an old script in my company. The guy who wrote it used a lot of "LEFT JOIN" whereas there is no specific conditions for joining, it's always natural joins. In that case why to use "LEFT JOIN" instead of "LEFT KEEP" which would keep 2 separate tables ?


      Is there an advantage that I don't see ?


      How do you choose between left join and left keep ?


      What do you think ?


      Thank you