Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: ??????????????ODBC ???????????????? SQL Server ????????????????

ACC2000: ??????????????ODBC ???????????????? SQL Server ????????????????

View products that this article applies to.

??

???? SQL Server ??????????????????????????????????????????????????????????????? ?????????????
ODBC--????????????

[Microsoft][ODBC SQL Server ?????][SQL Server] ????????? 'name' ?????????????????????????????????? (# 107)

↑ Back to the top

????

????????????????? Jet 4. 0 Service Pack ?????????? ??????????Microsoft Knowledge Base ??????????????: ????????????????????????? (Microsoft Knowledge Base) ???????????:
239114??: Microsoft Jet 4. 0 ?????? ???????? Service Pack ???????

↑ Back to the top

??

?????????????????????????????????????????????????? ????????? Jet 4. 0 Service Pack ?????????

↑ Back to the top

??

?????????

  1. SQL Server ? Northwind ??????????? DSN ???????
  2. Northwind ??????? Customers ?????Orders ???????? Order Details ????????????
  3. qryLevel1 ????????????????: 
    SELECT dbo_Customers.CompanyName, dbo_Orders.OrderID
FROM dbo_Customers INNER JOIN dbo_Orders ON dbo_Customers.CustomerID = dbo_Orders.CustomerID;
  4. qryFinal ????????????????: 
    SELECT [dbo_Order Details].ProductID, qryLevel1.OrderID
FROM [dbo_Order Details] LEFT JOIN qryLevel1 ON [dbo_Order Details].OrderID = qryLevel1.OrderID;
  5. qryFinal ?????????? ???????????????????????? ????????????? ??????????? Jet 4. 0 Service Pack ??????????????????????????????????

↑ Back to the top

?????

???????
??: ?????????? (???KB?) ???????????????????????????????????????????????????????????????????????????? KB ????????????????????????? KB ??????? KB ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? KB ??????????? KB ?????????????????????????????????????????????????????????????????????????????????????
??? KB:300830
Microsoft Knowledge Base ???: Microsoft Knowledge Base????????????????????????????????????Microsoft Corporation???????????????????????????????????????????????????????????Microsoft Corporation??????????????????????????????????????????????????�??????????Microsoft Corporation?????????????????????????????????????????????????????????????????????????????????????????Microsoft Corporation??????? ???????????????????????????????????????????????????????????????????????????????????(Microsoft Corporation??????? ???????????????????????????????????????) ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

↑ Back to the top

Article Info
Article ID : 300830
Revision : 1
Created on : 1/1/0001
Published on : 1/1/0001
Exists online : False
Views : 327