I have been doing sql development for years. I am very used to writing joins using the
SELECT ...FROM ...,... WHERE conditional clause. I find the SELECT ...FROM ... JOIN .... ON ....WHERE
condition clause not natural for me. I also find it awkward if there is any complexity to the query,
although this is probably just a matter of what you are used to.
I have been told that the conventions that I use may not be supported and I should switch
over. Is this true? I notice even BOL as a standard uses the select-from-where syntax