[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Questions re database schema - normalization

From: J Busser
Subject: Re: [Gnumed-devel] Questions re database schema - normalization
Date: Thu, 2 Sep 2004 08:44:59 -0700

At 7:03 AM +1000 9/4/04, sjtan wrote:
select.. natural join ..on ..  mechanism suggests
it's better to have a unique id name for each entity

I think we have fields named simply "id" in some tables.

Does this mean that
   if a join should have to operate on 2 tables
   selecting from each a field named "id"
that the syntax will stumble, and/or it is unwanted/extra work to have to provide aliases so as to be able to distinguish the column names and data from the two "id" fields in the output?

reply via email to

[Prev in Thread] Current Thread [Next in Thread]