MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Three(or Four)-Way Joins
Posted by: Rick James
Date: August 13, 2009 12:16AM

I don't see any need for "FROM (SELECT...)"; suggest you simplify to 
SELECT  ?.id, ?.companyid, ?.date, ?.income6,
        data2.geo1,
        data2.geo2
    FROM  subsample s
    JOIN  data1 ON s.companyid = data1.companyid
    JOIN  data2 ON s?.id=data2.id
(Since I can't see which fields are in which tables, I can't fill in the table aliases completely.)

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


Subject
Views
Written By
Posted
Three(or Four)-Way Joins
3762
Malcolm Wardlaw
August 11, 2009 07:10PM
Re: Three(or Four)-Way Joins
2120
Rick James
August 12, 2009 08:35PM
Re: Three(or Four)-Way Joins
1866
Malcolm Wardlaw
August 12, 2009 09:31PM
Re: Three(or Four)-Way Joins
1967
Rick James
August 13, 2009 12:16AM
Re: Three(or Four)-Way Joins
1946
Malcolm Wardlaw
August 13, 2009 12:26PM
Re: Three(or Four)-Way Joins
2644
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.