I have several tables of academic journal rankings, from different sources and with different metrics. I want to combine them in a single table, aggregating data by journal. The journals have several ISSN identifiers.
For example, the first table has columns:
ISSN1 ISSN2 Journal_Name_1 Impact_Factor
and the second table has columns
ISSN3 ISSN4 ISSN5 Journal_Name_2 Citations
Journal names vary between data sources, and any journal may have 0 or more ISSN numbers. What I would like to do is creating a new table with columns
ISSN1 ISSN2 ISSN3 ISSN4 ISSN5 Journal_name_1 Journal_Name_2 Impact_factor Citations
by merging a row from the first table with one from the second table if the condition
( Journal_Name_1 = Journal_Name_2 ) OR ( at least one of ISSN1 or ISSN2 is equal to at least one of ISSN3, ISSN4, ISSN5)
What is the most effective way to create that result?