Hi! 2 level derived SQL like this: select field1,field2,(select sum(f3) from (select f3 from b1 where b1.f2=a1.f2) a3 ) field3 from a1
SQL error, table a1 not found , that is a1.f2 not found Regards! Shuming Wang Xtech Company limited Room 29H, 29/F,Plaza 2, Tiancheng Building,No 96 Longkouxi Road, Tianhe Guangzhou,Guangdong,China http://www.xtech.com.cn http://www.87595959.com Email:[EMAIL PROTECTED] QQ:100200651 , MSN:[EMAIL PROTECTED] Tel:86-20-87595959, 86-755-61302424 ---2001,2002