ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  The Effective Use of Joins in Select Statements
Subject:   Thanks for a good article
Date:   2004-01-20 07:45:57
From:   anonymous2

very good!


but...
i could be wrong, but in principle 3 you write:



Select *
From t1
left outer join
(select *
from t2,t3
where (any where clause involving t1, t2, t3)
) t2_t3_composite_table on t1_t2_composite_table.f1 = t1.f1
,t4
,t5
,t6
Where (any clause involving t1, t2_te_composite_table, t4, t5, t6)


it looks to me like you've jumbled the name(s) of the temp-table. aren't
't2_t3_composite_table', 't1_t2_composite_table' and
't2_te_composite_table' all supposed to refer to the same thing?


again, thanks for a good article. i've always had a vague idea that
principle 6 was true, nice to see better info on that.


john guthrie


jguthrie@psynapsetech.com


1 to 1 of 1
  1. makeing progrme ....
    2007-08-19 08:33:13  sify.com [View]

1 to 1 of 1