> 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. >
And this is exactly the case. thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users