sql="select * from book"
循环 sqlgl=select sum(glzd) as glzd from guanlian where bookid=BOOK表的id
sqlgl1=select sum(glzd) as glzd1 from guanlian1 where bookid=BOOK表的id
sqlgl2=select sum(glzd) as glzd2 from guanlian2 where bookid=BOOK表的id循环结束这段代码 提高效率
请高手指点
循环 sqlgl=select sum(glzd) as glzd from guanlian where bookid=BOOK表的id
sqlgl1=select sum(glzd) as glzd1 from guanlian1 where bookid=BOOK表的id
sqlgl2=select sum(glzd) as glzd2 from guanlian2 where bookid=BOOK表的id循环结束这段代码 提高效率
请高手指点
--添加索引
--利用视图 存储过程 提高效率
这段代码没什么好优化的