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. Thanks in advance. Rahul Thathoo -- If real is characterized by what you see and what you can feel, then real is only electromagnetic impulses which run through you brain. -------------------------------------------------- Cheers! RAHUL THATHOO B.TECH(IT), 5th SEMESTER IIIT - ALLAHABAD PHONE: +91+532 2552505(ask for room 201) eHome: http://profile.iiita.ac.in/rthathoo_02 RYZE home: http://www.ryze.com/go/thathoo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
