I need to populate alias with the vendor reorder number. Can anyone supply me with SQL query to do this? Thanks in advance
please help
Mar 29, 2006
2 Replies
Craig,
Do a backup first!!
INSERT INTO Alias (Alias, ItemID) SELECT SupplierList.ReorderNumber, SupplierList.ItemID FROM SupplierList WHERE SupplierList.ReorderNumber NOT IN (Select ItemLookupCode from Item) AND SupplierList.ReorderNumber NOT IN (Select Alias from Alias)
DELETE Alias WHERE Alias IN (SELECT Alias FROM Alias WHERE Alias '' GROUP BY Alias HAVING COUNT(Alias) > 1)
DELETE Alias WHERE Alias = ''
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required