|
Posted by Sandy on 10/13/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);
Navigation:
[Reply to this message]
|