In reply to: > If the relationship is X.login = Y.login where each is a primary key > in the respective table then you should really reconsider the > structure of your db... they really should be one table.
That's only true if every record/row in table X has a corresponding record/row in table Y, with no null field/column values in either. However, if table Y only contains a matching record/row for some of the record/rows in table X, then separate tables is the correct way to go. It's a properly normalized database. Tom BareFeet _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
