Christopher Chamber <[EMAIL PROTECTED]> wrote: > Hi Everyone. My problem is that i want to create 2 instances of a > sub-query. For Example: > > SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name > = 'reviews' AND v2.sal = v1.sal ) v3 , v4 > > This query will gives an error as V4 is not allowed, i.e. not more than 1 > instance of a sub-query can be created. Is there a way around this > problem. I would not like to make this sub-query again to get another > instance of it. I need it very much, and if anyone can give me a way to do > it, i would be highly grateful.
Can you please describe what you mean by an "instance" of a query? It's not clear to me. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]