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 ?