On Wed, Sep 14, 2011 at 06:05, chetan rane <chetan.d.rane@xxxxxxxxx> wrote: > Hi, > > There are 2 peoblems with subselect > > 1. You cant use a limit on the nested select > 2. Id the number of elements in the in clause exceeds the subselect buffer > you will run into performance issues ans eventually you query will be > doomed. Inner joins in,this is the best option for this . You can use a temp > table for this > Thanks Chetan. I will keep that in mind if I ever get around to learning about subselects. Have a great day! -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
