Re: using multiple subtables efficiently
From: liz lawson <news_at_charitycards.co.uk>
Date: Mon, 1 Oct 2001 09:48:02 +0100
Message-Id: <1001925828.64820.1_at_hebe.uk.clara.net>
Date: Mon, 1 Oct 2001 09:48:02 +0100
Message-Id: <1001925828.64820.1_at_hebe.uk.clara.net>
>
>I've succesfully used both methods with the same group of tables. If you
store
>common data in table A, and specific details in tables a, b, c, d and e,
you
>probably have one or more columns in table A to classify the rows. You can
use
>this column for determining in which table the details are. But if you are
>SELECTing a list and you need data from several detail tables, the outer
join
>solution is simple and works fine.
>
Matti
Just a quick thanks for your help
Liz Received on Mon Oct 01 2001 - 10:48:02 CEST