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
Aamir KhanPosted Jun 28, 2012, 7:59 AM
just i have to use
select dbo.Inv_InventoryMaster.MaterialDesc+'-'+Inv_SupplierMaster.Supplier_Company_Name as Supplier
from table1
:)