Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #683

Re: joining

Show all headers | View raw

On Fri, 08 Aug 2014 11:55:25 -0500, Chris Riesbeck
<Chris.Riesbeck@gmail.com> wrote, quoted or indirectly quoted someone
who said :

>   select a.name, b.quote from authors a
>   join quotes b on a.id = b.id_author

a and b are just placeholders, right?

That gets you the set of all quotes, matched with the corresponding
author.

To get just one quote:

select authors.name, quotes.quote from authors join quotes on
authors.id = quote.id_author where quotes.id = nnnn;


That looks like it constructs a set of all the author's quotes, then
selects just one of them. Does it? Or is that just what it
conceptually does?



-- 
Roedy Green Canadian Mind Products http://mindprod.com
The art of strongly-typed language design is largely arranging 
that errors are automatically detected as soon as possible
in the compose, compile, run cycle.

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

joining Roedy Green <see_website@mindprod.com.invalid> - 2014-08-08 05:04 -0700
  Re: joining Lothar Kimmeringer <news200709@kimmeringer.de> - 2014-08-08 15:54 +0200
    Re: joining Chris Riesbeck <Chris.Riesbeck@gmail.com> - 2014-08-08 11:55 -0500
      Re: joining Roedy Green <see_website@mindprod.com.invalid> - 2014-08-08 19:19 -0700
        Re: joining Silvio <silvio@internet.com> - 2014-08-09 07:06 +0200
          Re: joining Roedy Green <see_website@mindprod.com.invalid> - 2014-08-09 02:45 -0700
            Re: joining Silvio <silvio@internet.com> - 2014-08-09 12:16 +0200
              Re: joining Chris Riesbeck <Chris.Riesbeck@gmail.com> - 2014-08-11 12:23 -0500

csiph-web