I appreciate the heads up. I don't have the access to check this for myself. I was going on what I was told. I'm working with SQL Server Express on...

I think I'll give slang's suggestion a try. It seems like it will work. I had thought about doing the multiple openqueries, but I'd still have to juggle multiple joins...