sql´íÎó °ïæ¿´¿´

Select A.*,B.ClassName,C.ClassName from Deal_Data A left join Shop_Class B On A.Shop_ID = B.ID Left join Item_Class C On A.Item_ID = C.ID

Õâ¾äsql²»ÄÜÔËÐÐ

´íÎóΪ

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Óï·¨´íÎó (²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ 'A.Shop_ID = B.ID Left Join Item_Class C On A.Item_ID = C.ID' ÖС£


µ«ÔÚsqlserverÖÐÈ´ÄÜÔËÐР

---

ÒýÓÃ

<br /> Select A.*,B.ClassName,C.ClassName from Deal_Data A left join Shop_Class B On A.Shop_ID = B.ID Left join Item_Class C On A.Item_ID = C.ID <br /> <br /> Õâ¾äsql²»ÄÜÔËÐÐ <br /> <br /> ´íÎóΪ <br /> <br /> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) <br /> [Microsoft][ODBC Microsoft Access Driver] Óï·¨´íÎó (²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ &#39;A.Shop_ID = B.ID Left Join Item_Class C On A.Item_ID = C.ID&#39; ÖС£ <br /> <br /> <br /> <span style="color:#FF0000">µ«ÔÚsqlserverÖÐÈ´ÄÜÔËÐÐ</span>

ÔÚÄÄ裡²»ÄÜ運ÐÐ?

---

[Microsoft][ODBC Microsoft Access Driver]

ACCESSµÄÓï·¨²»Í¬,

²Î¿¼ACCESSµÄÁ¬½ÓÓï·¨,

SQLSERVERÓ¦¸ÃÄÜÐÐ

---

Select A.*,B.ClassName,C.ClassName from Deal_Data A (left join Shop_Class B On A.Shop_ID = B.ID) Left join Item_Class C On A.Item_ID = C.ID

---

Òý