ok im trying to figure out a way to compare a table to another to find rows that no longer have a parent. similar to orphan thread but my only problem is that the column names are different but hold the same data. so the USE() function isnt possible and i do not think ON() will work because it will only find the rows that do coinside with table 1 from table 2. basically i want find journals that no longer have journalists and remove them.