SQL Joins
MS SQLA post on <cfsilence> today got me think of joins and the right vs wrong way to do things.
When doing an SQL inner join is it best to have something like
SELECT a.someThing1,a.someThing2
b.someThing1,b.someThing2
FROM someTable1 a INNER JOIN
someTable2 b ON a.someKey1 = b.someKey1
or something like this
SELECT a.someThing1,a.someThing2
b.someThing1,b.someThing2
FROM someTable1 a,
someTable2 b
WHERE a.someKey1 = b.someKey1
Notice the join is in the from statment in first example vs the where statement in the second example. Is there a difference betweent the two? Is one better than the other? How do you do it? How do you roll?
Good Day!
Ryan
SELECT a.something1, a.something2, b.something1, b.something2
FROM sometable1 a
INNER JOIN sometable2 b
ON a.somekey = b.somekey
This was a big flap in the Oracle world around version 8i because at that time Oracle didn't support the (LEFT|RIGHT)? JOIN syntax. A quick Google of "oracle outer join syntax" may net some usefule information for those who may be interested.
Loading....