INSERT INTO salesanalysis (typeabbrev,
												periodno,
												amt,
												cost,
												cust,
												custbranch,
												qty,
												disc,
												stockid,
												area,
												budgetoractual,
												salesperson,
												stkcategory )
								SELECT 'DE',
										'93',
										'36.2',
										'0',
										'TM013',
										'41',
										'2.1',
										'0',
										'SS',
										custbranch.area,
										1,
										'Zaabed Mohummed',
										stockmaster.categoryid
								FROM stockmaster, custbranch
								WHERE stockmaster.stockid = 'SS'
								AND custbranch.debtorno = 'TM013'
								AND custbranch.branchcode='41'