Yes that works great. Thanks Igor! On 11 February 2013 22:24, Igor Tandetnik <i...@tandetnik.org> wrote:
> On 2/11/2013 10:45 AM, e-mail mgbg25171 wrote: > >> 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. >> > > select * from MyTable where f1 = '' and f2 in > (select f3 from MyTable where f1 != ''); > > -- > Igor Tandetnik > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users