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 / Actually, Oracle also uses the JOIN syntax, as of version...
Post #75,837
by CRConrad
1/21/03 3:05:52 AM
Reply
New Actually, Oracle also uses the JOIN syntax, as of version...
...uh, nine-point-something. (Doesn't work on 8.1.7.2.0, which is what they have here at the client where I am right now.)

And I don't know if it recognizes the keyword 'INNER' -- as someone pointed out, absent a 'LEFT' or a 'RIGHT', the inner join is the default, so it may have been deemed unneccesary.

Anyway, it *is* much cleaner to express your join condition separately from the 'WHERE' clause's limiting condition.


   [link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad]
(I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link|http://z.iwethey.org/forums/render/content/show?contentid=71575|Ashton Brown]
Post #75,858
by ben_tilly
1/21/03 7:35:19 AM
Reply
New And that may be where my bias is from
Simultaneously using "big" databases that don't support it (eg Oracle 8) and Access that defaulted to it at the same time. Which left a taint of, "The stuff that Access produces doesn't work in 'real' databases."

Sort of like the * vs % for a wildcard.

Cheers,
Ben
"good ideas and bad code build communities, the other three combinations do not"
- [link|http://archives.real-time.com/pipermail/cocoon-devel/2000-October/003023.html|Stefano Mazzocchi]
     Trying to build a query (n00b) - (inthane-chan) - (20) - Jan. 20, 2003, 12:30:44 PM EST
         Off the top of my head - (JayMehaffey) - (8) - Jan. 20, 2003, 12:40:17 PM EST
             Blew my SQL engine... - (inthane-chan) - Jan. 20, 2003, 12:49:05 PM EST
             What is this INNER JOIN nonsense? - (ben_tilly) - (6) - Jan. 20, 2003, 01:14:46 PM EST
                 Why do you say that? - (JayMehaffey) - (5) - Jan. 20, 2003, 07:03:15 PM EST
                     /me relearns the value of double-checking references... - (ben_tilly) - (4) - Jan. 20, 2003, 07:23:54 PM EST
                         It works in MS SQL Server as well. - (orion) - Jan. 20, 2003, 08:21:58 PM EST
                         Actually, Oracle also uses the JOIN syntax, as of version... - (CRConrad) - (1) - Jan. 21, 2003, 03:05:52 AM EST
                             And that may be where my bias is from - (ben_tilly) - Jan. 21, 2003, 07:35:19 AM EST
                         I must be an exception. - (static) - Jan. 21, 2003, 06:18:46 AM EST
         Is this what you want? - (ChrisR) - (1) - Jan. 20, 2003, 12:48:58 PM EST
             That looks good... -NT - (inthane-chan) - Jan. 20, 2003, 12:50:00 PM EST
         Here I come to save the day - (orion) - Jan. 20, 2003, 12:50:13 PM EST
         Fixed. - (inthane-chan) - (1) - Jan. 20, 2003, 01:08:34 PM EST
             We posted around the same time - (orion) - Jan. 20, 2003, 08:23:07 PM EST
         this is how I'd do it - (SpiceWare) - (5) - Jan. 20, 2003, 02:06:41 PM EST
             Do you do that... - (inthane-chan) - (3) - Jan. 20, 2003, 02:06:00 PM EST
                 As to whether you *should* do that - (drewk) - Jan. 20, 2003, 02:24:33 PM EST
                 how's it guaranteed? - (SpiceWare) - (1) - Jan. 20, 2003, 02:30:06 PM EST
                     Enforced by DB. -NT - (inthane-chan) - Jan. 20, 2003, 02:53:02 PM EST
             This is how I'd do it - (drewk) - Jan. 20, 2003, 02:19:48 PM EST

We're gonna make this night... last fo-evah!
284 ms