本文介绍了我如何...在sql2008中联合2个表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
无法解决UNION操作中Persian_100_CI_AI和Arabic_CI_AS之间的排序规则冲突。
i在以下代码中出现此错误。
$ / b
选择lesscode，lessname，tedadevahed，noedars，magta from tblessons lesscode Not In（从tbentekhabevahed选择Lcode）union选择Lcode，Scode，lessname，tedadvahed，来自tbentekhabevahed的vaziat，其中vaziat ='1'
Cannot resolve the collation conflict between "Persian_100_CI_AI" and "Arabic_CI_AS" in the UNION operation.
i have this error in below code.
select lesscode,lessname,tedadevahed,noedars,magta from tblessons where lesscode Not In(select Lcode from tbentekhabevahed) union select Lcode,Scode,lessname,tedadvahed,vaziat from tbentekhabevahed where vaziat='1'
推荐答案
这篇关于我如何...在sql2008中联合2个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！