简单又复杂，大家帮小弟我看看咋回事啊
日期：2014-05-18 浏览次数：20468 次
简单又复杂，大家帮我看看怎么回事啊？
create TABLE t(pid INT,type VARCHAR(1),jiage1 INT,jiage2 INT,jiage3 INT)
INSERT INTO T
SELECT 1,'a',200,300,400 UNION ALL
SELECT 1,'b',100,500,400 UNION ALL
SELECT 2,'b',100,500,400 UNION ALL
SELECT 2,'c',300,500,400
select * from
(select a.pid,a.type,a.jiage1,a.jiage2,a.jiage3,
b.type,b.jiage1,b.jiage2,b.jiage3
from t a full join t b on a.pid=b.pid and a.type<>b.type) as h
错误： 多次为 'h' 指定了列 'type'。 这个是怎么回事，大家帮我看看啊
------解决方案--------------------
create TABLE t(pid INT,type VARCHAR(1),jiage1 INT,jiage2 INT,jiage3 INT)
INSERT INTO T
SELECT 1,'a',200,300,400 UNION ALL
SELECT 1,'b',100,500,400 UNION ALL
SELECT 2,'b',100,500,400 UNION ALL
SELECT 2,'c',300,500,400
select * from
(select a.pid,a.type,a.jiage1,a.jiage2,a.jiage3,
b.type,b.jiage1,b.jiage2,b.jiage3
from t a full join t b on a.pid=b.pid and a.type<>b.type) as h
错误： 多次为 'h' 指定了列 'type'。 这个是怎么回事，大家帮我看看啊
------解决方案--------------------
- SQL code
select * from
(
select
a.pid,a.type as atype,a.jiage1 as ajiage1,a.jiage2 as ajiage2,a.jiage3 as ajiage3,
b.type as btype,b.jiage1 as bjiage1,b.jiage2 as bjiage2,b.jiage3 as bjiage3
from t a full join t b
on a.pid=b.pid and a.type<>b.type
)
as h
/*
pid atype ajiage1 ajiage2 ajiage3 btype bjiage1 bjiage2 bjiage3
----------- ----- ----------- ----------- ----------- ----- ----------- ----------- -----------
1 a 200 300 400 b 100 500 400
1 b 100 500 400 a 200 300 400
2 b 100 500 400 c 300 500 400
2 c 300 500 400 b 100 500 400
*/
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
