select stageid, mfrid, noSaleReasonId, partnerid, partnertype, autoCaseAmt, autoIncomeAmt, autoWeightAmt, availableDate, opportunityDescription, portionsPerDay, unitsToServe, portionAmtOz, autoCaseAmt, caseAmt, autoIncomeAmt, incomeAmt, autoWeightAmt, weightAmt, OpportunityName, salesPersonUserId from tbl_spl_opportunities where opportunityid = and ownerid = and ownertype = update tbl_crm_interactions set mileage = where ownerid = and ownertype = and interactionid =