OK... bit of a soap box here. But I've been coding SQL for a lot of years, and I can tell from experience that there is very little consistency in formatting SQL, and some methods are better than others. Here's what I do.
I've read what the 'experts' say... and sometimes they're wrong too <smiles>
Ahem...