散文

SELECT a.tradecode,a.fullname,a.size,a.colour,a.unit,a.factory,a.qty,a.BarCode,a.price,b.FactoryZq FROM MerchInfo as a, Factory as b WHERE a.factory=b.FactoryName and a.factory=(SELECT FactoryName  FROM Factory where FactoryHead ='a') and a.tradecode ='1022'
SELECT sum((a.price-b.inprice)*a.qty) as 利润 FROM [SuperMarketdb].[dbo].[销售明细表] as a inner join [SuperMarketdb].[dbo].[MerchInfo] as b on Right(a.tradecode, Len(a.tradecode) - 1) =  b.tradecode  where billdate between '2011-03-25' and  '2011-03-25'and b.factory=(SELECT FactoryName  FROM Factory where FactoryHead ='a')

 

 

rs.Open "SELECT sum((a.price-b.inprice)*a.qty) as 利润  FROM [SuperMarketdb].[dbo].[销售明细表] as a inner join [SuperMarketdb].[dbo].[MerchInfo] as b on Right(a.tradecode, Len(a.tradecode) - 1) =  b.tradecode  where billdate between '" & DTPicker1.Value & "' and  '" & DTPicker2.Value & "' and b.factory=(SELECT FactoryName  FROM Factory where FactoryHead = left(a.tradeCode, 1))", cnMain, 1, 1