看看这个数据结构
A表结构：
Fields1 Fields2
1 2003
2 2003
3 2003
4 2003
5 2003
B表结构如下：
Fields1 Fields2 Fields3 Fields4
M R 100 2003
M C 100 2003
S D 100 2003
C表结构：
Fields1 Fields2 Fields3 Fields4 Fields5
1 M R 100 2003
2 M R 100 2003
3 M R 100 2003
4 M R 100 2003
5 M R 100 2003
1 M C 100 2003
2 M C 100 2003
3 M C 100 2003
4 M C 100 2003
5 M C 100 2003
1 S D 100 2003
2 S D 100 2003
3 S D 100 2003
4 S D 100 2003
5 S D 100 2003
将A，B两个表的数据合并为C表。当A或B表的数据列增加时，C表根据A或B自动增加并按C表的Fields1字段排序
问题点数：0、回复次数：4Top
1 楼Gelim（Gelim）回复于 2003-11-02 13:07:09 得分 0
sql语句如下！希望能对楼主有帮助！
SELECT A表.Fields1 AS Fields1, B表.Fields1 AS Fields2, B表.Fields2 AS Fields3, B表.Fields3 AS Fields4, B表.Fields4 AS Fields5
FROM A表, B表
WHERE (((A表.Fields2)=B表.Fields4))
ORDER BY A表.Fields1;
Top
2 楼zhujiechang（小朱）回复于 2003-11-02 17:28:59 得分 0
这种连接可以使用外连接Top
3 楼iiboy（漠漠星）回复于 2003-11-02 20:29:08 得分 0
sql语句如下！希望能对楼主有帮助！
if c表存在 then
drop c表
else
SELECT A表.Fields1 AS Fields1, B表.Fields1 AS Fields2, B表.Fields2 AS Fields3, B表.Fields3 AS Fields4, B表.Fields4 AS Fields5
FROM A表 inner join B表 on A表.Fields1=B表.Fields4
WHERE (((A表.Fields2)=B表.Fields4))
ORDER BY A表.Fields1 into c表
end if
Top
4 楼iiboy（漠漠星）回复于 2003-11-02 20:32:18 得分 0
不好意思,上面的写错了
应该是:
sql语句如下！希望能对楼主有帮助！
on (a表 or b表 有变化 )
if c表存在 then
drop c表
end if
SELECT A表.Fields1 AS Fields1, B表.Fields1 AS Fields2, B表.Fields2 AS Fields3, B表.Fields3 AS Fields4, B表.Fields4 AS Fields5 FROM A表 inner join B表 on A.Fields1=B表.Fields4 ORDER BY A表.Fields1 into c表
Top
