比如有这样一个查询
select s.*,t.*
from a as s,b as t
where s.aid=t.aid
我想把这个查询结果写入一个新的表C,这个C表是还不存在的,应该怎么写啊
select s.*,t.*
from a as s,b as t
where s.aid=t.aid
我想把这个查询结果写入一个新的表C,这个C表是还不存在的,应该怎么写啊
调试欢乐多
select s.*,t.*
into 新表
from a as s,b as t
where s.aid=t.aid
select s.*,t.* into C
from a as s,b as t
where s.aid=t.ai