Selecting distinct from multiple tables

[atsphpflash]

This is probably a very simply task for many of you - and I would appreciate your help:

I've got two tables with very similar data, except that one table has about 1,000 more records than the other. How can I select only those 1,000 records, that DO NOT appear in BOTH tables? I've tried a couple of things that look like this, but none of them give me what I'm looking for:

SELECT column FROM long_table WHERE column NOT IN ('SELECT column FROM short_table')

SELECT column FROM long_table WHERE column != ( 'SELECT column FROM short_table' )

SELECT DISTINCT (short_table.column), long_table.column FROM short_table, long_table

SELECT DISTINCT (long_table.column) FROM long_table, short_table

Thanks in advance...

[LordShryku]

Take a look in the manual for left join

SELECT l.column 
FROM long_table l
LEFT JOIN short_table s
ON l.column = s.column
WHERE s.column IS NULL

[atsphpflash]

Thanks