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

[J Busser]

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?