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
