lbass, sorry but i never done this in a query before
where and how would i implement this in my query
select main.rec_no as rec_no_Main,
main.user_id as User_id_Main,
main.User_last_name as User_last_name_main,
main.User_first_name as User_first_name_main,
main.User_middle_initial as User_middle_initial_main,
main.action_date as action_date_main,
main.Action_time as action_time_main,
main.Window_title as window_title_main,
main.Trans_id as Trans_id_main,
main.key_name as Key_Name_main,
main.key_value as key_value_main,
main.action_type as action_type_main,
main.workstation_id as workstation_id_main,
main.trans_succ as trans_succ_main,
main.review_status as review_status_main,
main.inq_sw as inq_sw_main,
(select [attribute name]
from mrextract.dbo.t_code code
where code.[tag id] = mod.col_name) as attribute_name,
mod.*
from mrextract.dbo.MR0052E_MAIN main
inner join mrextract.dbo.MR0052E_MOD mod on main.rec_no = mod.rec_no
where
(
(
'{?User_ID}' <> 'ALL' and
main.user_id = '{?User_ID}'
) or
'{?User_ID}' = 'ALL'
) and
( main.action_date > = {?Action Date Start}
and main.action_date <= {?Action Date End})
and
(
(
'{?Transaction Sucessful}' <> 'ALL' and
main.trans_succ = '{?Transaction Sucessful}'
) or
'{?Transaction Sucessful}' = 'ALL'
)
and
(
(
'{?Action Type}' <> 'ALL' and
main.action_type = '{?Action Type}'
) or
'{?Action Type}' = 'ALL'
)
