Subject Union in firebird
Author didinh2000
Why this statement doesn't work in firebird 1.5 ?

insert into employee (emp_id,emp_name,emp_zip,emp_loan)
select emp_id,'Name xxx','0001',emp_loan from loan_mtd
union
select emp_id,'Name xxx','0001',emp_loan from loan_ytd

or you've suggest for this problem ?

thank's