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

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

Re: joining

Show all headers | View raw

On Sat, 09 Aug 2014 07:06:31 +0200, Silvio <silvio@internet.com>
wrote, quoted or indirectly quoted someone who said :

>That is what it conceptually does. In SQL joins create sets (tables) 
>that combine tuples (records) from existing ones. Using selection (where 
>conditions) and projection (columns you select) operators reduces such 
>sets to the data you actually require. The RDBMS is responsible of 
>collecting that information in the most efficient way. And they are 
>extremely good at doing that. A lot better than what any program can 
>achieve by using it as a contemporary ISAM implementation.

The way I handle it now, I create a quote record, then look up a
author record by name, if I find one, I put its uniqueid number in the
quote record.  If it does not exist, I create one, fill in the fields.
and put its unique id number in the quote record.

Can that be handled as if there were one unified empty joined record
and I fill in all the fields.  It then hooks everything up, creating
as new author record as needed? or is join just for lookup?

-- 
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

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