
ANSI Join vs. WHERE Clause Join
Question: Is there a technical or logical difference between using an ANSI style join and specifying the join using the WHERE clause? Is there a general preference to either method, or is it solely dependent on your shop’s standards? Answer: No, there is good reason to adopt the new convention.