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!