Subject | Union in firebird |
---|---|
Author | didinh2000 |
Post date | 2005-08-16T02:29:12Z |
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
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