Re: not enough rows, too many rows, and joins
From: bugbear <bugbear_at_trim_papermule.co.uk_trim>
Date: Thu, 24 Feb 2005 09:58:38 +0000
Message-ID: <421da5bf$0$76387$ed2619ec_at_ptn-nntp-reader01.plus.net>
Date: Thu, 24 Feb 2005 09:58:38 +0000
Message-ID: <421da5bf$0$76387$ed2619ec_at_ptn-nntp-reader01.plus.net>
Paul wrote:
>
> Although it's not said explcitly I think the presumption is that no-one
> will have more than one car (though they may have more than one vehicle):
I do apologise; in further discussions here in my office, I realised that I "knew" that a person could only have 1 vehicle of each type, but hadn't expressed this either in unambiguous english, let alone SQL.
Oh, and thank to all for your information.
BugBear Received on Thu Feb 24 2005 - 10:58:38 CET