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

韩冰

写的真不错，大家可能用到 。 找出表a1,a2相同的列名： $ j" e" L0 a" T4 s" H$ N. Kselect left(A.name, 20) col, left(C.name,20) type, A.length from syscolumns A left join sysobjects B 3 E2 M+ s3 n }' ]- ^ on A.id = B.id left join systypes C o8 G" R9 I& i5 F: ~; ^. P on A.xtype = C.xtype 2 J, E) F& g5 j9 z; G where B.name = 'a1' or B.name = 'a2' group by A.name, C.name, A.length 1 T$ a, k1 e: d" a : w5 z$ A8 Y& m( F& N5 P7 t2 X3 R dhaving count(A.name) > 1 go ( x' |7 x# c' e' `0 F1 c/ ~* f 0 M# \/ f* l- k( r/ z8 w