MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Three(or Four)-Way Joins
Posted by: Malcolm Wardlaw
Date: August 12, 2009 09:31PM

Well the join I was performing looks something akin to the following 

SELECT id, companyid, date, income6, geo1, geo2 FROM
(SELECT id, companyid, date, income6 FROM subsample, data1 WHERE subsample.companyid = data1.companyid ) as A
JOIN data2
ON A.id=data2.id

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Three(or Four)-Way Joins
3886
Malcolm Wardlaw
August 11, 2009 07:10PM
Re: Three(or Four)-Way Joins
2167
Rick James
August 12, 2009 08:35PM
Re: Three(or Four)-Way Joins
1923
Malcolm Wardlaw
August 12, 2009 09:31PM
Re: Three(or Four)-Way Joins
2013
Rick James
August 13, 2009 12:16AM
Re: Three(or Four)-Way Joins
1997
Malcolm Wardlaw
August 13, 2009 12:26PM
Re: Three(or Four)-Way Joins
2698
Rick James
August 13, 2009 10:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.