问题描述
您好所有访客
我在sql server 2008中的连接表有问题.
我已经创建了2个表(客户和购买)
这些表通过使用customerCode(在Customer表中为primary)和customerCode(在Purchase表中为Foregn)进行链接.
这是我的查询:
Hi all visitors
i have problem with join tables in sql server 2008.
i have created 2 tables(customer and purchase)
these tables link by using customerCode(primary in Customer Table) and customerCode(Foregn in Purchase Table).
This is my query:
select*
from Customer T0
join Purchase T1 on T0.customercode=T1.customercode
当我执行时，它显示如下错误:
在等于操作中，无法解决"SQL_Latin1_General_CP1_CI_AS"和"Latin1_General_CI_AI"之间的排序规则冲突.
有人知道我如何加入他们吗?
最好的问候，
When i execute, it display error like this:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.
Anybody know how i can join them?
Best Regards,
推荐答案
这篇关于无法在SQL Server 2008中加入表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！