On Sat, 1 Mar 2008 18:04:12 -0500, "Stephen Oberholtzer" <[EMAIL PROTECTED]> wrote: >> INSERT INTO Table2 VALUES (NULL,"Some text in Table2"); >> INSERT INTO Table2 VALUES (NULL,"Some other text in Table2"); >> ===== >> INSERT INTO Table1 VALUES (NULL,"John Doe",1); >> INSERT INTO Table1 VALUES (NULL,"JaneDoe",2); >> ===== >> SELECT * FROM Table1,Table2 WHERE Table1.table2id=1; >> ===== >> 1|John Doe|1|1|Some text in Table2 >> 1|John Doe|1|2|Some other text in Table2 >> ===== > >I'm confused. Which one of those rows does not have table1.table2id=1?
Sorry for the imprecision: It's the same record, but why do I get two rows instead of one? I expected only the first one, since "Some text in Table2" has its ID = 1. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
