Question

sql2000如何查询两张表中相同的列名

比如有两张表A和B：
A中有列a, b, c, d
B中有列c, d, e, f

如何用一条SQL语句查询出两张表含有哪些相同的列（就上例而言，两个表包含相同的列c和d ）？

Answer 1

select a.name from
(select * from syscolumns where id=object_id(N'表A') )a
inner join
(
select * from syscolumns where id=object_id(N'表B')
) b
on a.name = b.name

Answer 2

select DISTINCT name from syscolumns where
name in (select name from syscolumns where id in
(select id from sysobjects where name in ('A')))
and
name in (select name from syscolumns where id in
(select id from sysobjects where name in ('B')))
order by name

Answer 3

带表名即可
select a.c,b.c,a.d,b.d from a,b

Answer 4

学习了