Say we have 2 tables, each with a text column, holding non-unique names. All names in table 1 are also in table 2 and vice-versa. The frequency of the names are different for both tables and this is the information I need to get.
So output should be like this: Names Table1_Count Table2_Count Percentage ------------------------------------------------------------------------ Name1 3 9 33.33 Name2 1 10 0.1 I am sure I am overlooking something simple, but not seen it yet. Thanks for any idea. RBS _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users