> If it’s joined to the BaseTbl by an integer primary key or FULLY joined by a > unique index then the table is redundant.
I’m talking **** there. If it’s an inner join SQLite needs to check the record exists in the joined table. Sorry about that, back to left joins. _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users