Koen Verbeeck (8/5/2014)
Phil Parkin (8/5/2014)
Unless your database is case-sensitive, you don't need the UPPERs.Also you should always qualify your tables with their schema.
And you should finish your statements with the semicolon operator. 😉
Hah, yes! 🙂
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.