On Sat, 1 Mar 2008 15:27:19 -0500, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote: >What do you mean, all the rows? Are you saying the resultset contains >some rows where table1_field10 is not equal to table2_field1? With all >due respect, I find it very hard to believe.
That's what happens, though. FWIW, I'm using 3.5.6: ===== CREATE TABLE Table1 (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, table2id INTEGER); CREATE TABLE Table2 (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT); ===== 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 expected only the first row, but I got two :-/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
