YAN HONG YE <yanhong...@mpsa.com> wrote: > mysql sql cmd is: > > select tb2.bb,tb2.cc,(max(tb1.mdate)-min(tb1.mdate)) as mmd,(mmd. > max(tb1.mdate).cc-mmd. min(tb1.mdate).cc) as mmc from tb1,tb2 > where tb2.bb in (select bb from tb1 where bb group by bb having count(bb)) ;
With all due respect, this query doesn't make any sense. Could you explain in your own words exactly what data do you want to calculate? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users