sql hvor table1.id ikke findes i table2.team1 eller table2.team2

Sådan?

SELECT *
FROM table1
WHERE id NOT IN
(
    SELECT id
    FROM tabel2
)

mange tak. Det var lige præcis det. :) Lav lige et svar, så vil du få point.

nej vent, jeg får følgende fejlmeddelelse, når jeg bruger "IN (SELECT team1,team2 FROM table2)":

You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.

Det går dog fint, når jeg kun henter team1 eller team2..

SELECT *
FROM table1
WHERE id NOT IN
(
    SELECT team1 AS id FROM table2
    UNION
    SELECT team2 AS id FROM table2
)

tak. =) opret gerne et svar.

Svar :^)