Re: Informal Survey #1 -- joins on foreign keys
Date: Sun, 2 Oct 2011 09:07:11 -0700 (PDT)
Message-ID: <c1c21b9c-0275-4d38-8d21-f2ac5beff678_at_hd1g2000vbb.googlegroups.com>
On Oct 1, 2:07 pm, Rob <rmpsf..._at_gmail.com> wrote:
...
> I've designed hundreds of databases. After contemplating it long and
> hard, I seriously
> doubt I ever used a foreignkey-foreign key join in the queries I
> authored for use with
> these databases. Not because it was disallowed, but because
> it lacks meaning. ...
There must be thousands of db's that have Shipments, Invoices and Receivables tables with a foreign key referencing a Customer table. Obviously there will be people who will want to join two or more of those tables to compare Shipment_Value to Invoice_Amount or Receivable_Amount.
Of course there are probably thousands, maybe millions, of people who have designed hundreds of databases that used no such join. And, probably thousands of people who have designed dozens of databases that used only such joins. Received on Sun Oct 02 2011 - 18:07:11 CEST