Join Appending Items To Bottom

Question

Join Appending Items To Bottom

lynn1233

SSC Enthusiast

Points: 101
More actions
February 2, 2017 at 12:09 pm

#318549

Inventory
Item Description PO  Ordered Due
APEN Nice Pen
PO
Item PO  Ordered Due
APEN 123456 01012017 02022017
INSERT INTO #Inventory (PO, Ordered, Due)
SELECT #PO.PO, #PO.Ordered, #PO.Due
FROM #PO
left JOIN #Inventory ON #Inventory.Item = #PO.Item
It is not joining the items. It appends it to the bottom. Can anyone tell me what I'm doing wrong? I don't see any spaces in the item numbers, and have tried every join I can think of. Thank you.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247180 More actions · Answer 1

lynn1233 - Thursday, February 2, 2017 12:09 PM
Inventory
Item Description PO  Ordered Due
APEN Nice Pen
PO
Item PO  Ordered Due
APEN 123456 01012017 02022017
INSERT INTO #Inventory (PO, Ordered, Due)
SELECT #PO.PO, #PO.Ordered, #PO.Due
FROM #PO
left JOIN #Inventory ON #Inventory.Item = #PO.Item
It is not joining the items. It appends it to the bottom. Can anyone tell me what I'm doing wrong? I don't see any spaces in the item numbers, and have tried every join I can think of. Thank you.

It is doing the join, and then inserting the results of the join into #inventory. You need an UPDATE query, by the look of it, not an INSERT.

Update i set PO = p.PO, Ordered = p.Ordered, Due = p.Due FROM #PO p JOIN #Inventory i ON i.Item = p.Item

lynn1233 SSC Enthusiast Points: 101 More actions · Answer 2

Thank you. That worked. Must not be getting enough sleep. Thanks again.