http://community.csdn.net/Expert/TopicView.asp?id=4786545
问题解决了,但是
显示
BrandMaster.BMName as A1
和ProductMaster.ProdName as A1
怎么做比较好?
在
zjcxc(邹建)
龙卷风2006
两位大哥的帮助下,问题解决.但是出现了上面的问题BrandMaster.BMName as A1
和ProductMaster.ProdName as A1
两个字段, 类型完全一样SELECT Score.*,BrandMaster.BMName as A1
FROM Score INNER JOIN
ConsumerAnswerDetail
ON Score.QID = ConsumerAnswerDetail.QID
AND Score.QOID = ConsumerAnswerDetail.QOID
LEFT OUTER JOIN
ProductMaster
ON Score.PGID = ProductMaster.PMID
WHERE Score.IsBrand=0
UNION ALL
SELECT Score.*,ProductMaster.ProdName as A1
FROM Score INNER JOIN
ConsumerAnswerDetail
ON Score.QID = ConsumerAnswerDetail.QID
AND Score.QOID = ConsumerAnswerDetail.QOID
LEFT OUTER JOIN
BrandMaster ON Score.PGID = BrandMaster.BMID
WHERE Score.IsBrand=1
问题解决了,但是
显示
BrandMaster.BMName as A1
和ProductMaster.ProdName as A1
怎么做比较好?
在
zjcxc(邹建)
龙卷风2006
两位大哥的帮助下,问题解决.但是出现了上面的问题BrandMaster.BMName as A1
和ProductMaster.ProdName as A1
两个字段, 类型完全一样SELECT Score.*,BrandMaster.BMName as A1
FROM Score INNER JOIN
ConsumerAnswerDetail
ON Score.QID = ConsumerAnswerDetail.QID
AND Score.QOID = ConsumerAnswerDetail.QOID
LEFT OUTER JOIN
ProductMaster
ON Score.PGID = ProductMaster.PMID
WHERE Score.IsBrand=0
UNION ALL
SELECT Score.*,ProductMaster.ProdName as A1
FROM Score INNER JOIN
ConsumerAnswerDetail
ON Score.QID = ConsumerAnswerDetail.QID
AND Score.QOID = ConsumerAnswerDetail.QOID
LEFT OUTER JOIN
BrandMaster ON Score.PGID = BrandMaster.BMID
WHERE Score.IsBrand=1
解决方案 »
- 如何设置tempdb自增大小??????
- OLE DB 提供程序 'SQLOLEDB' 无法启动分布式事务,请高手帮帮忙!
- sql补丁
- 在触发器里面的INSERTED是什么意思
- 大家帮我看一下 从.bak文件还原数据库时总是出错
- 求教用T-SQL语句创建表的问题
- 关于存储过程的一个问题
- 怎样使用MSSQL 2000 的删除触发器建立删除日志。---过江项羽
- sql server2000的联机分析工具可以作为数据挖掘的工具吗?
- [C++ Error] Unit1.cpp(24): E2288 Pointer to structure required on left side of -> or ->*是啥意思?
- 查询的问题,典型!!
- 兄弟们,这个SQL语句可能比较麻烦,帮帮忙给看看。谢谢了!
龙卷风2006
两位大哥近来接分吧SELECT Score.*,ProductMaster.ProdName as A1
FROM Score INNER JOIN
ConsumerAnswerDetail
ON Score.QID = ConsumerAnswerDetail.QID
AND Score.QOID = ConsumerAnswerDetail.QOID
LEFT OUTER JOIN
ProductMaster
ON Score.PGID = ProductMaster.PMID
WHERE Score.IsBrand=0
UNION ALL
SELECT Score.*,BrandMaster.BMName as A1
FROM Score INNER JOIN
ConsumerAnswerDetail
ON Score.QID = ConsumerAnswerDetail.QID
AND Score.QOID = ConsumerAnswerDetail.QOID
LEFT OUTER JOIN
BrandMaster ON Score.PGID = BrandMaster.BMID
WHERE Score.IsBrand=1