From: Elim Qiu Date: July 13 2011 7:26pm Subject: Re: query for twin primes List-Archive: http://lists.mysql.com/mysql/225374 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable > How about: > > select =A0t1.pv, t2.pv from prime t1, prime t2 where t2.pv=3Dt1.pv+2 and > t1.oid<1000000 order by t2.pv > > Mike Very nice and simple. Thanks Mike! Also Thanks Singer X.J. Wang and shawn wilson. best regards, Elim