1# MORR 发表于 2006-09-16 15:37

sql语句

当有多个表格有同结构数据，查询时可以用联合
复制内容到剪贴板
代码:
SELECT cli, dnis, call_time, talk_dur, charge
FROM (SELECT cli, dnis, call_time, talk_dur, charge
        FROM CDR20060904
        UNION
        SELECT cli, dnis, call_time, talk_dur, charge
        FROM CDR20060905) DERIVEDTBL
WHERE (cli = '6010')
ORDER BY call_time