Wow!Thank you guys again!

It appears my training book is outdated.

Looks like they made some significant syntax changes from SQL 2006 to SQL 2008.

I will have to find a tutorial for...