Is there any difference (speed, elegance, etc.) between these statements? The CF query builder seens to make the second, which seems wrong. SELECT * FROM Services INNER JOIN Operators ON Services.OperatorID = Operators.OperatorID SELECT * FROM Services WHERE Services.OperatorID = Operators.OperatorID