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
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:
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.