select a.EDPNo, b.PVC, a.EachWeight, c.VendNo, c.TermsPct, c.FrtCharge, c.FreeFrt, c.FrtAsPct, c.FrtChargePct, --c.FreeFrt = 1 (b.PVC - (b.PVC * (c.TermsPct / 100))) as Calc1, --c.FrtAsPct = 1 (b.PVC + (b.PVC * (c.FrtChargePct / 100))) - (b.PVC * (c.TermsPct / 100)) as Calc2, --c.FreeFrt = 0 & c.FrtAsPct = 0 (b.PVC + (c.FrtCharge * a.EachWeight)) - (b.PVC * (c.TermsPct / 100)) as Calc3 from DS1.dbo.ItemMst a join DS1.dbo.PItems b on a.EDPNo = b.EDPNo inner join DS1.dbo.VendorMst c on a.VendNo = c.VendNoThanks,