评论会员:游客 时间:2012/02/07
尝试为codeprelang="SQL"spanclass="code-keyword"select/spana.col1,a.col2,a.col3,b.col1,b.col2spanclass="code-keyword"from/spantableaa,tablebbspanclass="code-keyword"where/span[spanclass="code-keyword"Join/spanCondition]/pre/code
palraj001
评论会员:游客 时间:2012/02/07
您好u能得到你的解决方案,此查询codeprespanclass="code-keyword"select/spanspanclass="code-string"'/spanspanclass="code-string"1'/spanspanclass="code-keyword"as/spancol1,spanclass="code-string"'/spanspanclass="code-string"abc'/spanspanclass="code-keyword"as/spancol2,spanclass="code-string"'/spanspanclass="code-string"one'/spanspanclass="code-keyword"as/spancol3spanclass="code-keyword"into/span#temp1spanclass="code-keyword"union/spanspanclass="code-keyword"select/spanspanclass="code-string"'/spanspanclass="code-string"2'/span,spanclass="code-string"'/spanspanclass="code-string"def'/span,spanclass="code-string"'/spanspanclass="code-string"two'/spanspanclass="code-keyword"select/spanspanclass="code-string"'/spanspanclass="code-string"a'/spanspanclass="code-keyword"as/spancol1,spanclass="code-string"'/spanspanclass="code-string"12'/spanspanclass="code-keyword"as/spancol2,spanclass="code-string"'/spanspanclass="code-string"one'/spanspanclass="code-keyword"as/spancol3spanclass="code-keyword"into/span#temp2spanclass="code-keyword"union/spanspanclass="code-keyword"select/spanspanclass="code-string"'/spanspanclass="code-string"b'/span,spanclass="code-string"'/spanspanclass="code-string"31'/span,spanclass="code-string"'/spanspanclass="code-string"two'/spanspanclass="code-keyword"select/span#temp1.col1,#temp1.col2,#temp1.col3spanclass="code-keyword"from/span#temp1spanclass="code-keyword"full/spanspanclass="code-keyword"outer/spanspanclass="code-keyword"join/span#temp2spanclass="code-keyword"on/span#temp1.col3=#temp2.col3 spanclass="code-keyword"drop/spanspanclass="code-keyword"table/span#temp1spanclass="code-keyword"drop/spanspanclass="code-keyword"table/span#temp2/pre/code的