两表合并

Question

例如 表a字段名 product
             002
             003
             004
    表b字段名 product
             005
             006
             007
我想用sql语名合并两表
   使dbgrid的product 同时显示为
              002
            003
            004
            005
            006
            007
怎么写呀

Answer 1

用select into把两个表合并为一个临时表吧

Answer 2

select product from 表B union all select product from 表A ORDER BY product