G
Guest
I need to build a query with expressions with the following logic:
ExpressionA
AND
(ExpressionB OR ExpressionC)
AND
(ExpressionD OR ExpressionE)
I was assuming the SQL Statement View would be the most efficient way to
implement this query because in Design View I would have to use several OR
rows repeating expressions in several rows and it seemed to me that the
resulting SQL Statement would be unnecessarily verbose.
I started building this in SQL Statement View and switched to Designer View
just for curiosity. I noticed in Design View multiple OR rows were created,
repeating ExpressionA in the rows, which I realize is necessary to implement
the logic.
My question is if I use SQL Statement View will the query be more efficient
or is it just as efficient to use Design View?
Thanks,
John
ExpressionA
AND
(ExpressionB OR ExpressionC)
AND
(ExpressionD OR ExpressionE)
I was assuming the SQL Statement View would be the most efficient way to
implement this query because in Design View I would have to use several OR
rows repeating expressions in several rows and it seemed to me that the
resulting SQL Statement would be unnecessarily verbose.
I started building this in SQL Statement View and switched to Designer View
just for curiosity. I noticed in Design View multiple OR rows were created,
repeating ExpressionA in the rows, which I realize is necessary to implement
the logic.
My question is if I use SQL Statement View will the query be more efficient
or is it just as efficient to use Design View?
Thanks,
John