I'm doing a package tracking feature for the website of a delivery service out here. I'm trying to perform an inner join based on the success of an if statement in my sql query.

I have to write a query on a positively atrocious table (this is with MSSQL 2005). Basically, multiple "lists" are stored in a single gigantic table called "UserData". I'm building the SQL statement ...