if you break it apart does it work? Like, do the select first, then if that returns fine, run it w/ the join etc....dunno if you did this, but I always build outward. Also, i've gotten in the habit of using DB.dbo.table, like grifter said.