I tried the following both are not working in SPT. Any idea?

"insert into emp_master (emp_id,fir_name,passport_no) SELECT RTRIM(?ep_id),?fr_name,?pass_p from johu1 where not exists
(select 1 from emp_master where RTRIM(emp_id)=RTRIM(?ep_id))"

Another way.....

insert into emp_master (emp_id,fir_name,passport_no) select RTRIM(johu1.ep_id),johu1.fr_name,johu1.pass_p from johu1 where not exists
(select 1 from emp_master where RTRIM(emp_id)=RTRIM(johu1.ep_id))"


Thanks Again