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

韩冰

写的真不错，大家可能用到 。 . k, p. V. T2 m: X ^4 ^找出表a1,a2相同的列名： 9 M5 |7 a/ \/ `& X , ^1 e- V' {$ V' o, Cselect left(A.name, 20) col, left(C.name,20) type, A.length from / q2 p9 [2 x5 { 4 O* y8 B+ X# @* H# T syscolumns A left join sysobjects B 8 k" j o: G4 n% O3 z$ e$ y, _0 } 3 u% E* ]0 s( _! ]6 x( D on A.id = B.id left join systypes C " G( G1 b' k! s( F8 _* @) Z/ { / P8 C# j* c, }0 \5 w- Z on A.xtype = C.xtype & a+ d. U( ~- J t; b where B.name = 'a1' or B.name = 'a2' ! y9 V; e/ y( N& |* n- G' g group by A.name, C.name, A.length / N7 [; B1 N# l( G& b + ~" H9 h/ _# B& U# e2 chaving count(A.name) > 1 ( r1 `. W: n6 A7 |9 ?4 Wgo : T" D* b2 o( |2 | 8 {6 N( }- D) I8 c