• Taking out the parentesis arround the select statement fixed it.

    The Redneck DBA