I want to be able to add two 'AND' conditions for one column in Query Builder, I can only see an option to create one 'AND' and one 'OR'. Can this be done?
AND table1.start_date BETWEEN table2.in_time AND table2.out_time
AND start_date IS NOT NULL
Currently, as designed, you can create only two 'Where' conditions joined by an Or condition only.
It is possible to add a 'Global Where Clause' by right-clicking on the Query Builder Pane or create a 'Calculated Field' again by right-clicking on the query builder pane, but this may not meet your logic requirements.
Creating a 'Global where clause' for the above example results in the following code:
SELECT TEST_TABLE1.COL_ID, TEST_TABLE1.START_DATE
FROM CUST_TEST.TEST_TABLE1 TEST_TABLE1, CUST_TEST.TEST_TABLE2 TEST_TABLE2
WHERE (TEST_TABLE1.COL_ID = TEST_TABLE2.COL_ID)
AND (TEST_TABLE1.START_DATE BETWEEN TEST_TABLE2.IN_TIME
AND (TEST_TABLE1.START_DATE IS NOT NULL)