[RESOLVED] Select query where not in two fields?

[gwerner]

I have a select query that I am trying to get all id's from table 1 that don't also exist in two fields from table 2.

SELECT FROM table1
WHERE document_id NOT IN (SELECT document_id1, document_id2 FROM table2)

The above doesn't seem to work unless I remove one of the fields (document_id1, document_id2). If only 1 field is in the NOT IN portion of the select it works. However, I need it to check both fields and not return any id's from table 1 that exist in either field in table 2. Is this possible? Or, is there another way?

[gammaster]

My query writing is a bit rusty, and I havent checked it, but try this.

SELECT table1.id FROM table1 LEFT JOIN table2 ON
(table1.id = table2.id1 OR table1.id = table2.id2)
WHERE (table2.id1 AND table2.id2) IS NULL

[gwerner]

Well, your rusty is better than my futile attempts. That did the trick. Thanks for the help.