Re: EXISTS Clause

2003-11-03 Thread Victoria Reznichenko
Heinrich Stoellinger <[EMAIL PROTECTED]> wrote: > Does MySQL support the "EXISTS" / "NOT EXISTS" clause in table query > statements? It's supported since version 4.1 > What I want to do is to find tuples which do NOT have > corresponding tuples in ano

EXISTS Clause

2003-11-02 Thread Heinrich Stoellinger
Does MySQL support the "EXISTS" / "NOT EXISTS" clause in table query statements? What I want to do is to find tuples which do NOT have corresponding tuples in another table. For example - tell me who in my person table does not have an email address. -- MySQL General M