Query

Question

Dear Friends i have a query for SQL following is my SQL query select which gives me Output like below: Red top plain tube 4.0 ml.Nidhi Life Care but i need format like (Red top plain tube 4.0 ml. - Nidhi Life Care) pl reply aamir dbo . Inv_InventoryMaster . MaterialDesc + Inv_SupplierMaster . Supplier_Company_Name as Descriptions from Inv_InventoryMaster inner join Inv_SupplierMaster on Inv_InventoryMaster . SPL_ID = Inv_SupplierMaster . SPL_ID

Aamir Khan · Answer

its done just i have to use select dbo . Inv_InventoryMaster . MaterialDesc + '-' + Inv_SupplierMaster . Supplier_Company_Name as Supplier from table1 :)