Re: SQL question - duplicate records from join

On 4 Mar 2002 at 8:22, Stephan Szabo wrote:

> I recently upgraded to Postgres 7.1 (having finally found the
> correct pg_dump!), and now I notice that joins are returning
> duplicate records. A typical query would be:

I got it sorted - it turned out that there was some ambiguity in the
values being used to join tables.

Sincere thanks to all who replied, both on- and off-list!

--Ray.

---------------------------------------------------------
Raymond O'Donnell            http://www.iol.ie/~rod/organ
rod@iol.ie                      The Irish Pipe Organ Page
---------------------------------------------------------