SQL + VB

Question

TABLE1 no         indate
A0001      2004-01-02 08:00:00
A0001      2004-01-02 13:30:00
 
TABLE2 NO         OUTDATE
A0001      2004-01-02 12:00:00
A0001      2004-01-02 17:30:00TABLE3  DATE         NO       TIME
2004-01-02   A0001    08:00:00
2004-01-02   A0001    12:00:00
2004-01-02   A0001    13:30:00
2004-01-02   A0001    17:30:00TABLE4DATE         NO        TIME1         TIME2       TIME3      TIME4
2004-01-02   A0001    08:00:00     12:00:00    13:30:00    17:30:00想要根据TABLE1，TABLE2的数据形成TABLE3 或TABLE4，烦请帮助用VB

Answer 1

Access表实现table3:
select format(indate,"yyyy-mm-dd") as [date],
       [no],
       format(indate,"hh:mm:ss") as [time]
from table1
union all
select format(outdate,"yyyy-mm-dd") as [date],
       [no],
       format(outdate,"hh:mm:ss") as [time]
from table2