I
ifcansee
Unregistered / Unconfirmed
GUEST, unregistred user!
select t1.seiz+t2.seiz+t3.seiz-t4.seiz-t5.seiz,t1.answ+t2.answ+t3.answ-t4.anse-
t5.answ,t1.serl+t2.serl+t3.serl-t4.serl-t5.serl,t1.rerl+t2.rerl+t3.rerl-t4.rerl-
t5.rerl from t1,t2,t3,t4,t5
t1,t2,t3,t4,t5都为本地表,记录也就万条左右,p4的机器,128m内存,只见硬盘狂闪,
搞了好长时间,最后是出错信息,该语句应该没错吧?!
t5.answ,t1.serl+t2.serl+t3.serl-t4.serl-t5.serl,t1.rerl+t2.rerl+t3.rerl-t4.rerl-
t5.rerl from t1,t2,t3,t4,t5
t1,t2,t3,t4,t5都为本地表,记录也就万条左右,p4的机器,128m内存,只见硬盘狂闪,
搞了好长时间,最后是出错信息,该语句应该没错吧?!