A表包含name,address
B表包含pinyin,zhuzhi
比如A表里createtime字段包含1329895557(20120222),1327133691(20120121)
B表里issuedtime字段包含1326105212(2012-01-09),1325322988(2011-12-31)
怎么把A表和B表里的内容合并到一个表里,并按照createtime和issuedtime的前后排序?
而且A、B表的name和pinyin合并到一个字段,A、B表的address和zhuzhi合并到一个字段
B表包含pinyin,zhuzhi
比如A表里createtime字段包含1329895557(20120222),1327133691(20120121)
B表里issuedtime字段包含1326105212(2012-01-09),1325322988(2011-12-31)
怎么把A表和B表里的内容合并到一个表里,并按照createtime和issuedtime的前后排序?
而且A、B表的name和pinyin合并到一个字段,A、B表的address和zhuzhi合并到一个字段
A表:createtime(number(15)),name(varchar2(30)),address(varchar2(30))
B表:issuedtime(number(15)),xingming(varchar2(30)),dizhi(varchar2(30))要求用select把A、B表的这三个字段合到一起,然后按createtime和issuedtime的前后排序。
1329895557(20120222), 李明, 北京
1327133691(20120121), 王东, 天津
B表:issuedtime(number(15)),xingming(varchar2(30)),dizhi(varchar2(30))
1326105212(2012-01-09),zhangsan, beijing
1325322988(2011-12-31), lisi, tianjin 合并成的C表如下,然后按照time的时间顺序排值:
time(number(15)), all_name(varchar2(30)),all_address(varchar2(30))
1329895557(20120222), 李明, 北京
1327133691(20120121), 王东, 天津
1326105212(2012-01-09),zhangsan, beijing
1325322988(2011-12-31), lisi, tianjin 1329895557是日期2012-02-22的毫秒值(从1970-01-01到2012-02-22之间的毫秒数),可以用get_microsecond(to_date('2012-03-06','yyyy-MM-dd')) from dual来获得
1329895557(20120222),张三, 北京
1327133691(20120121),李四, 天津B表:issuedtime(number(15)),xingming(varchar2(30)),dizhi(varchar2(30))
1326105212(2012-01-09),Jack, USA
1325322988(2011-12-31), Tom, Canada合并后的C表为,然后按time排序:
time(number(15)),all_name(varchar2(30)),all_address(varchar2(30))
1329895557(20120222),张三, 北京
1327133691(20120121),李四, 天津
1326105212(2012-01-09),Jack, USA
1325322988(2011-12-31), Tom, Canada1329895557是2012-02-22的毫秒值,可以用select get_microsecond(to_date('2012-03-06','yyyy-MM-dd')) from dual函数得到有人知道怎么合并这2个表到一个view里吗?
SELECT * FROM (
SELECT createtime,NAME,address FROM t2 UNION ALL
SELECT issuedtime,xingming,dizhi FROM t4
)ORDER BY createtime DESC