i need sql statment that will insert the reorder number for an item as alias this way it will be alot easier to make a purchase order & can we add the first letter of the supplier to the reorder number for example if i have a supplier named target & the reorder number for this item is 5327 can we write a statment to add T5327 as alias for that item thanks
badly needed sql statment
Mar 04, 2007
1 Replies
Hi Maher, I can help you in this, Run this query INSERT INTO ALIAS (ITEMID,ALIAS) SELECT ItemID,(Left(SupplierName,1)+ReorderNumber) FROM SUPPLIER INNER JOIN SupplierList ON Supplier.ID=SupplierList.SupplierID WHERE Len(ReorderNumber)>=1
Rate Please me.
"maher almasri" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required