From: Perrin Harkins Date: March 17 2009 4:58pm Subject: Re: Negated SELECT query List-Archive: http://lists.mysql.com/mysql/216767 Message-Id: <66887a3d0903170958i21672526w15d34045d0a5a005@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Tue, Mar 17, 2009 at 12:42 PM, BobSharp wrote: > These have been written successfully with Sub-Queries, > I would like to know how they can be done with only JOINs =A0? http://dev.mysql.com/doc/refman/5.0/en/rewriting-subqueries.html - Perrin