Two Instances

[Rahul Thathoo]

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]

time complexity

[Rahul Thathoo]

Hello. My dilemma is: which of the two is more complex(i mean the time
complexity)

1 single join of n tables having t tuples each amounting to t^n tuples
preceded by one Select * statement; OR

n joins of 2 tables having t tuples each amounting to n*t^2 tuples
n Select * statements

Question :::

Whether the time complexity depends on the no of tuples in the joined
table or the no. of joins and the no. of select statements?

Thanks in advance.

-- 
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]