Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!193.201.147.82.MISMATCH!hitnews.eu!feeder1.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!z12g2000yqz.googlegroups.com!not-for-mail From: paul c Newsgroups: comp.databases.theory Subject: Re: Informal Survey #1 -- joins on foreign keys Date: Sun, 2 Oct 2011 09:16:30 -0700 (PDT) Organization: http://groups.google.com Lines: 10 Message-ID: <203e74bb-9511-4926-b3f4-3ddd28aa997d@z12g2000yqz.googlegroups.com> References: <469d9627-f72a-4720-a5ea-ec1171291e0e@k10g2000vbn.googlegroups.com> <0d04e155-0599-4401-834c-7c8ea4f19f74@dm9g2000vbb.googlegroups.com> NNTP-Posting-Host: 50.92.173.91 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1317572190 30663 127.0.0.1 (2 Oct 2011 16:16:30 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sun, 2 Oct 2011 16:16:30 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: z12g2000yqz.googlegroups.com; posting-host=50.92.173.91; posting-account=1V7IQgoAAABd7BhWccyRqi-lsW3llrFD User-Agent: G2/1.0 X-Google-Web-Client: true X-Google-Header-Order: HNKUARELSC X-HTTP-UserAgent: Mozilla/5.0 (Windows NT 6.0) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.186 Safari/535.1,gzip(gfe) Xref: news.cambrium.nl On Oct 1, 2:07=A0pm, Rob wrote: ... > Mechanically, there is nothing to it. ... Mechanically, there is plenty to it. The first SQL implementers were obviously terrified of joins, which in part led to the conceptual mess we have today such as screwball concepts like inner and outer joins, ON DELETE CASCADE, etc. The official SQL standard is of such a size that no single person could master it and have time left over for anything else.