Path: csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!news.glorb.com!postnews.google.com!w21g2000yqm.googlegroups.com!not-for-mail From: Robert Klemme Newsgroups: comp.lang.java.programmer Subject: Re: SQL Puzzle - too many dimensions Date: Tue, 10 May 2011 00:06:26 -0700 (PDT) Organization: http://groups.google.com Lines: 24 Message-ID: References: <3Boxp.9547$HF3.5013@newsfe03.iad> <92r02mF24dU1@mid.individual.net> NNTP-Posting-Host: 193.0.246.21 Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1305011186 11207 127.0.0.1 (10 May 2011 07:06:26 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 10 May 2011 07:06:26 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: w21g2000yqm.googlegroups.com; posting-host=193.0.246.21; posting-account=MGO7qgoAAABvyo26eHVDO00044spH-ws User-Agent: G2/1.0 X-HTTP-Via: 1.1 webwasher (Webwasher 6.7.2.3448) X-HTTP-UserAgent: Mozilla/5.0 (Windows NT 5.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1,gzip(gfe) Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.programmer:3902 On 10 Mai, 03:50, Lawrence D'Oliveiro wrote: > In message <92r02mF24...@mid.individual.net>, Robert Klemme wrote: > > > That's called an "inline view". > > The only reason there=92s a special term for it is because SQL doesn=92t = treat > tables/views as first-class objects. There are no objects in SQL. SQL is neither procedural nor object oriented. It is a declarative language implementing relational algebra. > This is an example of a situation where a little bit more orthogonality > could have made the language much simpler. This is an empty claim as long as you do not prove in what ways it could be made simpler. Lawrence, is there /anything/ you are comfortable with the way it is? Good luck robert