select * from hbc order by cmc desc limit 10 union select * from hbc where qph>0 union select * from hbc where hctl=1
this sql cmd cause the error: order by clause should come after union not before _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users