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

韩冰

写的真不错，大家可能用到 。 找出表a1,a2相同的列名： select left(A.name, 20) col, left(C.name,20) type, A.length from 8 b& ]! W2 ^6 K1 K syscolumns A left join sysobjects B 4 S: ]' U K& V5 Y2 A; }, e( { on A.id = B.id left join systypes C ) y' g, L4 G, i- A on A.xtype = C.xtype ) h0 x7 @* W' E* H: x6 p- n. X where B.name = 'a1' or B.name = 'a2' " y( e1 T' L# Y5 A) K. _ . x& n; ^' l# \: l8 [+ ^group by A.name, C.name, A.length # y6 w2 z5 B& f) N having count(A.name) > 1 / t. @2 |- W6 o) N4 A 4 o, M6 c5 L( \6 F0 T/ l+ o& Ogo 6 X! \3 J& a0 ] r- i2 N5 w2 a