Posted by Sandy on 10/14/31 11:48

If u can use union even this would work :
SELECT phone
FROM a
WHERE phone NOT
IN (
SELECT phone
FROM c
UNION SELECT phone
FROM b
)

strawberry wrote:
> Assuming you can use nested SELECTs then I think this syntax would
> work...
>
> SELECT DISTINCT(table_a.string) from table_a WHERE table_a.string NOT
> IN (SELECT DISTINCT(string) FROM table_b) AND table_a.string NOT IN
> (SELECT DISTINCT(string) FROM table_c);

[Back to original message]