1. Home
  2. Point-Of-Sale Software
  3. please help

please help

I need to populate alias with the vendor reorder number. Can anyone supply me with SQL query to do this? Thanks in advance

Reply to
Craig
Loading thread data ...

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 = ''

Reply to
Jeff

Reply to
Craig

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.