Matt Osbun wrote: > Why? Not a challenge, but a question. Using *= or (+) always seemed, > at least to me, quicker, easier, and easier to read afterward. > > Now, I admit that I mostly got into the habit because, until fairly > recently, I was stuck on an Oracle platform that was too old to use > INNER JOIN/LEFT JOIN, but how much does it really matter?
Ask 10 developers that got their BSc in CS during the last 12 months to explain both syntaxes. Extrapolate that to three or five years in the future. Will your replacement still be able to read your code? *= and (+) are deprecated, legacy, on their way out. They may very well last 4 more decades in some obscure COBOL application, but just as you should use IsDefined instead of ParameterExists, you should use LEFT JOIN syntax. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201544 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
