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 DescriptionsfromInv_InventoryMasterinnerjoin Inv_SupplierMaster onInv_InventoryMaster.SPL_ID=Inv_SupplierMaster.SPL_ID