I have a question: Based on your queries, it looks like you have multiple tables with the same columns. Is that correct?
The way you're trying to use Case looks like Visual Basic. It doesn't work that way in SQL.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon