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.)
Subject
Views
Written By
Posted
3862
August 11, 2009 07:10PM
2156
August 12, 2009 08:35PM
1915
August 12, 2009 09:31PM
Re: Three(or Four)-Way Joins
2002
August 13, 2009 12:16AM
1989
August 13, 2009 12:26PM
2686
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.