Lorna,
I come across this all the time and agree that it frustrates me. I think Matt hit the nail on the head in the previous comment.
One book I recommend is
Joe Celko’s SQL Programming Style
http://www.amazon.com/Celkos-Programming-Kaufmann-Management-Systems/dp/0120887975
It’s fantastic!