SELECT * FROM
Table 1,
Table 2
where
(
Table2."PRODUCT_CODE" in ('400', '500', '600')
and
"Table 1"."AMOUNT_FLAG" in ('s', 'd')
and
case when ("Table 1"."AMOUNT_TYP" in ('Credit', 'Debit')) then "Table 1".AMOUNT else 0 end <> 0
or
"Table2"."PRODUCT_CODE" in ('600', '410')
and
"Table 1"."AMOUNT_FLAG" in ('i', 'c', 's')
and
"Table2"."PRODUCT_NUM" <> '203'
or
"Table2"."PRODUCT_NUM" = '203'
and
"Table1"."AMOUNT_FLAG" in ('s', 'd')
and
case when ("Table 1"."AMOUNT_TYP" in ('Credit', 'Debit')) then "Table 1"."AMOUNT" else 0 end <> 0 )
-----Now,my question is that how can i write this filter condition into load script editor or report sheet??
----can i handle this filter into sheet ??
----tell me the exact expression for this filter condition
