There are more fields in each table, but for the sake of brevity, I ommited them from the snippets below.
With smaller data sets, the second query works just fine as well. SELECT COUNT(*) FROM link; 960219 SELECT COUNT(*) FROM node; 812193 Pvid's are INTEGERS. On linux, the following query executes just fine from the interactive shell: "SELECT COUNT(*) FROM link ld LEFT OUTER JOIN node n ON n.pvid = ld.light_node_pvid WHERE ld.light_node_pvid != '-1' AND ld.light_node_pvid != '-2' AND n.pvid IS NULL;" But, this one appears to hang(note the white space and eols in this one): "SELECT COUNT(*) FROM link ld LEFT OUTER JOIN node n ON n.pvid = ld.light_node_pvid WHERE ld.light_node_pvid != '-1' AND ld.light_node_pvid != '-2' AND n.pvid IS NULL;" I get the same results with perl::dbi. Any idea's? The information contained in this communication may be CONFIDENTIAL and is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender and delete/destroy the original message and any copy of it from your computer or paper files. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users