> ===== > 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 :-/
I'm confused. Which one of those rows does not have table1.table2id=1? -- -- Stevie-O Real programmers use COPY CON PROGRAM.EXE _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users