Re: [SQLObject] creating joins

[David M. C. <da...@da...>]

On Tue, Apr 29, 2003 at 11:36:13AM -0500, Nick wrote:

> Most non-MySQL schema designers (in my experience, anyway) tend to name
> columns that are the same data the same in every table they appear in. 
> That means, if person_id is in Address, then the key in Person is
> person_id as well.  This uncomplicates JOINS in a major way, 

It's called a natural join.  In postgres if you name your columns this way
you can do

select * from person join address

and it automatically does the join on the common column.

Dave Cook