D1.rsB.Open "SELECT A.ID,B.Pzz,C.KhName " & _
"FROM Invoice A " & _
"Left Join Client C ON A.KH = C.ID " & _
"Left Join InvoiceZ B ON A.Pzz=B.ID "这条语句在SQLSERVER中可行,但在ACCESS中不行.
在ACCESS中是不是不能二个LEFT JOIN一起用呢?
"FROM Invoice A " & _
"Left Join Client C ON A.KH = C.ID " & _
"Left Join InvoiceZ B ON A.Pzz=B.ID "这条语句在SQLSERVER中可行,但在ACCESS中不行.
在ACCESS中是不是不能二个LEFT JOIN一起用呢?
"FROM Invoice A " & _
"Left Join Client C ON A.KH = C.ID ) D" & _
"Left Join InvoiceZ B ON D.Pzz=B.ID "
为了给你回铁我还要注册,真麻烦,留下QQ回复会方便点
"FROM Invoice A " & _
"Left Join Client C ON A.KH = C.ID ) D" & _
"Left Join InvoiceZ B ON D.Pzz=B.ID "