WHERE clause translation to Query Builder
Posted: Fri Dec 08, 2017 12:08 pm
Hi
I have a WHERE clause in a SQL statement looking like the following and have difficulties to translate it to Query Builder as I don't get twice two ANDs combined with the OR. Any hints are welcome.
Regards,
I have a WHERE clause in a SQL statement looking like the following and have difficulties to translate it to Query Builder as I don't get twice two ANDs combined with the OR. Any hints are welcome.
- Code: Select all
WHERE
((cm.class_level_number = 4
AND cm.class_sign IN ('ma','mb','mc','na','nb'))
OR (cm.class_level_number = 3
AND cm.class_sign IN ('fa', 'fb')))
Regards,