> where exists ( > select 1 from master_table where > master_table.id=detail_table.masterid and > masterfieldtocheck = okvalue and > masterfield2tocheck = okvalue2); > > -- or > > where detail_table.masterid in ( > select id from master_table where > masterfieldtocheck = okvalue and > masterfield2tocheck = okvalue2); > > -- > Igor Tandetnik > > Thanks,Igor, it works, I see that sql itself is smart enough ) Both suggested by you are similar in speed, but the latter looks more self-explanatory for me.
Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users