yaconsult <yacons...@yahoo.com> wrote: > User Accounts > name > uid > server > login > . > . > . > > Calendar Accounts > server > login > firstname > lastname > . > . > . > > > What I need to be able to do is to check > that the server and login information > in the first table matches one and only > one of the accounts in the second table.
select * from UserAccounts u where 1 != ( select count(*) from CalendarAccounts c where c.server = u.server and c.login = u.login ); This will return all the "bad" records in UserAccounts. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
