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 need to create a three table inner join. It works correctly in SQL Analyzer, but fails when I run it inside ADO.NET.<BR>Here is a simplified query of what I am trying to do:<BR><BR>SELECT a.ID, b.ID ...