INSERT salesanalysis ( typeabbrev,
												periodno,
												amt,
												cost,
												cust,
												custbranch,
												qty,
												disc,
												stockid,
												area,
												budgetoractual,
												salesperson,
												stkcategory)
										SELECT 'DE',
												'93',
												'-86.1',
												'0',
												'TM013',
												'41',
												'-6.15',
												'0',
												'BTS',
												custbranch.area,
												1,
												'fe',
												stockmaster.categoryid
										FROM stockmaster,
												custbranch
										WHERE stockmaster.stockid = 'BTS'
										AND custbranch.debtorno = 'TM013'
										AND custbranch.branchcode='41'