你能帮我查一下吗。表1(输入)有三列(贷方日期、借方日期、付款日期),表2(输出)有一列日期表1中的三列值应在表2中可用。我试过了,但没用。
insert into table2 select date from ( (select credit_date, debit_date, Payment_date from table 1) as date)t;
请你带路好吗。
xn1cxnb41#
尝试执行联合所有:
insert into table2 select * from ( select credit_date as date from table1 union all select debit_date as date from table1 union all select payment_date as date from table1 ) t
1条答案
按热度按时间xn1cxnb41#
尝试执行联合所有: