generate list of files NOT in BOTH tables

[mrsocks]

hello,

i have two table of lists of files. 5500 in one and 6500 in the other. i want to generate a list of the files that are NOT in BOTH tables.

i am using left join but it doens tseem to be working.

here is what i am using so far.
table 1: id|sc_name
table 2: id2|sc_name2

$sql1 = "select sc_name.images, sc_name2.images2
from images left join images2
on sc_name.images = sc_name2.images2";

$sql_result1 = mysql_query($sql1,$connection)
or die("Couldn't execute query number 1.");

$sql2 = "select sc_name.images, sc_name2.images2
from images left join images2
using (name)
where sc_name.images is null ORDER BY sc_name asc";

$sql_result2 = mysql_query($sql2,$connection)
or die("Couldn't execute query number 2.");

while ($row = mysql_fetch_array($sql_result2)) {
$sc_name = $row["sc_name"];

echo "$sc_name";

[gofrm]

try this:

$sql1 = "select sc_name.images, sc_name2.images2 from images left join images2 on sc_name.images = sc_name2.images2 [b]where sc_name2.images2 is null[/b]";