> How about: > > select t1.pv, t2.pv from prime t1, prime t2 where t2.pv=t1.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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
