Noonan

I have an opportunity to get myself into a better position at work. However, I need to know the basics of SQL programming. I have experience in working within databases which were created using SQL but none when it comes to the programming. Can anyone recommend a book for someone just starting out? I found a few searching on B&N's site but I don't know which one to go with.