Posted by Steve Jorgensen on 10/18/05 18:56

On 18 Oct 2005 08:36:39 -0700, wackyphill@yahoo.com wrote:

>Ok, so is the idea is to remember to always do outer joins w/ the
>address table to get all the info available?

Once you have the structure, there are lots of options for how to retrive data
from it. An outer join to each and every "child" table is one option, or you
can add an address type column, and have the client do a second query to
retrieve the details of an address from the appropriate place.

[Back to original message]