你能帮我查一下吗。表1（输入）有三列（贷方日期、借方日期、付款日期），表2（输出）有一列日期表1中的三列值应在表2中可用。我试过了，但没用。
insert into table2select date from ( (select credit_date, debit_date, Payment_date from table 1) as date)t;
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 table1union allselect debit_date as date from table1union allselect payment_date as date from table1) t
select * from (
select credit_date as date from table1
union all
select debit_date as date from table1
select payment_date as date from table1
) t
1条答案
按热度按时间xn1cxnb41#
尝试执行联合所有：