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.