Question

在这里输入图像描述 I 正在 VB. Net 连接 SQL 服务器2008

此工程 - & gt; Dim 查询 = "SELECT wo. workorderID,wo. workorder no from dbo. workorder wo"

this does not work - > Dim 查询 = "SELECT wo. workorderID,wo. workorderID,wo. workorderNo, wood. wood. 从dbo. workorderwo, dbo. workorder details wood" 。
this does not working either - > Dim 查询 = "SELECT wo. workorderID,wo. workorder No, workorder no, wood. workorderwo, dbo. workorder details wod where wwo. workorderID = wod. workorderID" 。这都行不通 - & gt; Dim查询 = "SELECT WWO.wo. worOorderorderd. wororderd.Oderid.d.d.did.did.did.d.d." 。" " 。

我假设是因为在《工作批号》中, 工作批号有多个相同的身份识别码

In WorkOrder the WorkOrderID seems to be incremental.. 1,2,3 etc..

In WorkOrderDetails the WorkOrderID is like this.. 1,1,1,1,1,1,2,2,2,2,3,3,3,3,3,3 etc..

有什么办法能成功吗?

Incorrent syntax near the keyword "LineNo". Is the error I get

我刚刚也尝试过这个 - & gt; “ SELECT WorkorderID, workorder No, 线从 dbo. workorder JOIN dbo. workorder details on dbo. workorder. workorder. workorderID = dbo. workord Details. workordid”

似乎没有工作。相同的错误

Answer 1

LineNo is a 保留的关键词。使用 Destrict Ididationation 。

SELECT WorkOrderID, WorkOrderNo, [LineNo]
FROM dbo.WorkOrder
  JOIN dbo.WorkOrderDetails
    ON dbo.WorkOrder.WorkOrderID = dbo.WorkOrderDetails.WorkOrderID

Answer 2

使用加入( U) :

Dim query = 
"SELECT wo.WorkOrderID,
       wo.WorkOrderNo, 
       wod.[LineNo] FROM dbo.WorkOrder wo
                 JOIN dbo.WorkOrderDetails wod 
                 ON wo.WorkOrderID = wod.WorkOrderID"

这个网站会帮助您启动 :

"http://www.w3schools.com/sql/default.asp" rel="nolfollow">sql 辅导

最佳区域

友情链接