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 / What is this INNER JOIN nonsense?
Post #75,687
by ben_tilly
1/20/03 1:14:11 PM
1/20/03 1:14:46 PM
Reply
New What is this INNER JOIN nonsense?
How can I tell that you have worked with Access far more than real database engines..?

Hint: INNER JOIN is not part of SQL.

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]
Expand Edited by ben_tilly Jan. 20, 2003, 01:14:46 PM EST
Expand All History
Post #75,764
by JayMehaffey
1/20/03 7:03:15 PM
Reply
New Why do you say that?
The only references I have are MS, so I don't doubt they could be wrong.

But I was under the impression that JOIN is a standard part of SQL. The INNER part is probably the default join option, so I could have left that out.

In any case, what I gave above does work on SQL Server.

Jay
Post #75,772
by ben_tilly
1/20/03 7:23:54 PM
Reply
New /me relearns the value of double-checking references...
It turns out that INNER JOIN is in the ANSI 92 standard.

However virtually the only place that I have seen it used is Access. And certainly I have never seen anyone working on a non-Microsoft database who uses the INNER JOIN syntax. We all do as, say, Spiceware did above and put the joins in the WHERE clause.

Sorry for my misimpression, but the general observation holds. Microsoft uses the INNER JOIN syntax, but you don't see many non-Microsoft people using it.

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]
Post #75,788
by orion
Picture of orion
1/20/03 8:21:58 PM
Reply
New It works in MS SQL Server as well.
I recall using it a lot when I was a SQL Server programmer.

[link|http://pub75.ezboard.com/bantiiwethey|
New and improved, Chicken Delvits!]
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]
Post #75,848
by static
Picture of static
1/21/03 6:18:46 AM
Reply
New I must be an exception.
I've been using INNER JOIN in MySQL extensively for the past year. Haven't programming in Access for several years (got sick of fighting VBA, amongst other things) but that was before I really learned SQL.

MySQL's doco mentions it: [link|http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOIN|http://www.mysql.com...ference.html#JOIN]

Maybe it's syntactic sugar, but it works for me. Particularly when I have to figure out a LEFT JOIN or a RIGHT JOIN as the set imagery is, I find, consistent.

Wade.

Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed
 
Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please

-- "Anything but Ordinary" by Avril Lavigne.
     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

UNAPOTHEGMATIC MAN
97 ms