Hello, i need to to do this: i have this table: "userrates", composed by: id, userid, idtitle, rate.
for example: (1, 12, 1, 3) (2, 15, 99, 4) (3, 22, 10, 1) (10, 22, 1, 5) (5, 166, 37, 1) (4, 244, 10, 2) (6, 298, 1, 4) (7, 298, 10, 3) (8, 298, 15, 2) i need to extract only the rows with the userid who had voted both fims (1 and 10): the result will be: (3, 22, 10, 1) (10, 22, 1, 5) (6, 298, 1, 4) (7, 298, 10, 3) How can i do that? Thanks in advance, Luca -- View this message in context: http://old.nabble.com/Select-tp30425149p30425149.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
