Perhaps I'm making a meal of my question... "All" I want to do is select only records that have field f1 = '' where it's other field f2 matches the value of f3 only in other records (1 or more) which have a non-'' f1 value.
To explain the f1 field shows whether or not the record has been written to a treeview or not i.e. non-'' means it has been written and let's say that f2 is the parent node...and f3 is the old node handle for one of the nodes just written. This is probably a better summary of what I'm trying to do. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users