I have three tables, each of which has the column rpsIndex. This column is not a unique index/primary key.
I would like to count the number of times each rpsIndex appears in all three tables. E.g. Table1 rpsIndex=1 rpsIndex=1 rpsIndex=2 Table2 rpsIndex=1 rpsIndex=2 rpsIndex=3 Table3 rpsIndex=3 rpsIndex=3 rpsIndex=3 Query would return: rpsIndex Frequency 1 3 2 2 3 4 It is possible to do this in pure SQL in SQLite? Many thanks jon -- View this message in context: http://www.nabble.com/Counting-rows-in-multiple-tables-and-joining-on-an-index-tp15547081p15547081.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users