IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / I like that description.
Post #29,534
by static
Picture of static
2/24/02 12:34:51 AM
Reply
New I like that description.
It's really good - makes the different options make sense. Thanks!

Oh - and Bryce, "Left Outer" vs "Right Outer" is really a semantic convenience. You should theoretically always be able to make a Right Outer Join into a Left Outer Join by swapping the table names in the Join clause. I've not tried it, though, as probably 99% of the Joins I do are Inner.

Wade.

"All around me are nothing but fakes
Come with me on the biggest fake of all!"
Post #29,642
by CRConrad
2/25/02 12:48:00 PM
Reply
New You're welcome! (Both of you... ;^)
     Question on LEFT JOIN - (drewk) - (12) - Feb. 12, 2002, 02:46:08 PM EST
         An unspecified joining query *is* a left join - (kmself) - (8) - Feb. 12, 2002, 03:03:37 PM EST
             Hmm, I don't think so - (drewk) - (7) - Feb. 12, 2002, 03:10:53 PM EST
                 No, "JOIN [tables] ON [condition]" is Standard SQL-92 AFAIK. -NT - (CRConrad) - Feb. 12, 2002, 05:38:08 PM EST
                 Left Join. - (static) - (5) - Feb. 12, 2002, 10:17:34 PM EST
                     re: inner/outer left/right joins - (tablizer) - (4) - Feb. 20, 2002, 01:07:50 PM EST
                         Nope, they're really more kind'a the same thing. - (CRConrad) - (3) - Feb. 20, 2002, 01:58:16 PM EST
                             Anybody ever do a FULL OUTER ? - (tablizer) - Feb. 21, 2002, 01:54:34 PM EST
                             I like that description. - (static) - (1) - Feb. 24, 2002, 12:34:51 AM EST
                                 You're welcome! (Both of you... ;^) -NT - (CRConrad) - Feb. 25, 2002, 12:48:00 PM EST
         been a long time but wouldnt a stripped seek be faster - (boxley) - (2) - Feb. 12, 2002, 03:20:15 PM EST
             Gaah, just got the answer - (drewk) - (1) - Feb. 12, 2002, 03:28:43 PM EST
                 Yup. The speed depends more on the dataset - (tseliot) - Feb. 13, 2002, 10:21:53 AM EST

We're talking "filled with angry bees" levels of agony.
35 ms