同时查询3张不太一样的表,
table1:
id
name
sex
fax
file
email(不同)
-----------
table2:
id
name
sex
fax
file
phone(不同)
-----------
table3:
id
name
sex
fax
file
address(不同)
把name sex fax file 读出来,但是并把他们的记录 写入1.txt 2.txt 3.txt中;
当然这样比较变态,我可以分别读取,然后在分别写.问题是我想把他们union 起来,让后rs.movenext.可以吗?
[解决办法]
三张表有关联的字段吗
[解决办法]
why有这么2的三个表？
[解决办法]
没看懂.
可用ID连接吗?
select tb1.* , tb2.phone, tb3.address from tb1
full join tb2 on tb1.id = tb2.id
full join tb3 on tb1.id = tb3.id
[解决办法]
不明白你是什么意思
select name, sex, fax, file, '1 ' as tabname, email as difcol from table1
union
select name, sex, fax, file, '2 ' as tabname, phone as difcol from table2
union
select name, sex, fax, file, '3 ' as tabname, address as difcol from table3
你生成的联合表中你对tabname字段进行判定,根据值记到文本N中
