我正在尝试在一个查询中联接两个GP10表(SOP10100 & SOP10200)

Question

我一直收到以下错误

Msg 208, Level 16, State 1, Line 1
Invalid object name 'SOPNUMBE'.

有人能指出我的错误吗？这是我第一次使用内连接。

我的代码如下：

Select SOPNUMBE, SOPTYPE, DOCDATE,
ORDRDATE, CMPNTSEQ, ITEMNMBR, QUANTITY,
UNITCOST, UNITPRCE, EXTDCOST, XTNDPRCE
From SOP10100
INNER JOIN SOPNUMBE
On SOP10100.SOPNUMBE = SOP10200.SOPNUMBE

Answer 1

您正在加入一个不存在的table..further，请使用别名以提高可读性。

Select  s1.SOPNUMBE, SOPTYPE, DOCDATE, ORDRDATE, CMPNTSEQ, ITEMNMBR, QUANTITY, UNITCOST, UNITPRCE, EXTDCOST, XTNDPRCE
From    SOP10100 s1
INNER JOIN SOPNUMBE s2
On      s1.SOPNUMBE = s2.SOPNUMBE

你的版本应该是这样的..

Select  SOPNUMBE, SOPTYPE, DOCDATE, ORDRDATE, CMPNTSEQ, ITEMNMBR, QUANTITY, UNITCOST, UNITPRCE, EXTDCOST, XTNDPRCE
From    SOP10100
INNER JOIN SOPNUMBE
On      SOP10100.SOPNUMBE = SOPNUMBE.SOPNUMBE

Answer 2

我想你想要的是：

Select  SOPNUMBE, SOPTYPE, DOCDATE, ORDRDATE, CMPNTSEQ, ITEMNMBR, QUANTITY, UNITCOST, UNITPRCE, EXTDCOST, XTNDPRCE
From    SOP10100
INNER JOIN SOP10200
On      SOP10100.SOPNUMBE = SOP10200.SOPNUMBE