select edi.dbo.Receipt.*,expopdat.dbo.fd101.船名,expopdat.dbo.fd101.航次,expopdat.dbo.fd101.开航日 from edi.dbo.Receipt inner join expopdat.dbo.fd101 on edi.dbo.Receipt.分单编号=expopdat.dbo.fd101.定舱编号
Error;Cannot resolve collation conflict for equal to operation.
select a.*,b.* from 库a..表a a join 库b..表b b on a.列=b.列
SELECT * FROM Northwind.dbo.Customers a INNER JOIN authors b ON a.CustomerID = b.au_id通过了
from edi.dbo.Receipt inner join expopdat.dbo.fd101 on edi.dbo.Receipt.分单编号=expopdat.dbo.fd101.定舱编号
FROM Northwind.dbo.Customers a INNER JOIN
authors b ON a.CustomerID = b.au_id通过了