rocknbil - 5:46 pm on May 30, 2011 (gmt 0)

It means there are no columns that match the criteria . . . when fuzzled with joins, break down the statements. Output the joining column and do a straight select . . .


SELECT Details.OrderID, Details.Description, Details.DetailValue Details

Now pick one of the order ID's and compare it with straight selects on the other two tables.

SELECT SavedConfigurations.OrderID from SavedConfigurations where SavedConfigurations.OrderID = 'one-of-the-order-ids' AND SavedConfigurations.Name='TEST123'

"SELECT Variables.VariableName, Variables.Value
FROM Variables where Variables.OrderID = 'one-of-the-order-ids' and Variables.VariableName = 'URL1'

You'll probably find an empty set for at least one of the two joins.