Re: Multi Table Join
Date: 1995/07/09
Message-ID: <3tpb0n$82h_at_maverick.tad.eds.com>#1/1
galigian_at_on.bell.ca wrote:
>
> Here's one for you guys. I need to perform a multi table join.
> For example, the tables are as follows.
> Table A (Primary) Table B Table C
> ----------------- ------- -------
> Key = NAME NAME NAME
> HOURS_WORKED EXPENSES
> DATE
> The relationship between A and B is one to many , and
> the relationship between A and C is one to many.
The problem, as I see it, is that joining all three tables the relationship between ( AB) to C is M:1 ! That's why you're getting the expense column duplicated. I think your logical model is way out of whack. Received on Sun Jul 09 1995 - 00:00:00 CEST