如何取得两个表相同的列名

韩冰

写的真不错，大家可能用到 。 找出表a1,a2相同的列名： 6 E0 O- N7 N2 q+ d/ M* Wselect left(A.name, 20) col, left(C.name,20) type, A.length from : v8 |2 B( l# V) z0 O5 n0 s syscolumns A left join sysobjects B 8 `2 Z3 u6 X2 z1 x( A on A.id = B.id left join systypes C " e$ V& V5 C& N. Z: n 6 m& o& e0 z* D' s, h9 }% p1 B on A.xtype = C.xtype ; o0 G+ C) ?* N/ ]1 m where B.name = 'a1' or B.name = 'a2' group by A.name, C.name, A.length + u4 c2 Q, ]* G0 ~7 U, Ihaving count(A.name) > 1 ) D! |: _' Z' Z {( Y' S go 1 h2 d# M6 D$ N