Hi,

 

Programmer wrote the below query for me to run the report. I tried to convert it in the Crystal Report. But I do not have idea how to do the 'and'

& 'or' together in 'Select Expert' in CR?

 

SELECT * FROM TA_USER
WHERE emp_id IN (
SELECT distinct m.emp_id FROM
TA_TRANS_HISTORY T, TA_MASTER_HISTORY M
WHERE T.ta_id = M.ta_id
AND T.tc_id = 43
AND ((M.pay_period > 20 AND M.leave_year = 2009)
OR (M.pay_period <= 11 AND M.leave_year = 2010)
OR (M.pay_period = 20 AND M.leave_year = 2009
AND (t.day4 + t.day5 + t.day6 + t.day7 + t.day8 + t.day9 + t.day10 + t.day11 + t.day12 + t.day13) > 0 )))