Re: Problems with join (no such attribute, but it exists)

On Wed, 14 May 2003 12:30:07 -0400, Matej Cepl <cepl(at)surfbest(dot)net>
wrote:
> grass=> \d tracts_towns2000
> Table "tracts_towns2000"
> Column | Type | Modifiers
> -----------+-----------------------+-----------
> COMPL_ID | character varying(18) | not null
> COUNTY_ID | smallint | not null
> TRACT_ID | integer | not null
> TOWN_ID | smallint | not null
> AREA_ID | smallint | not null
> Primary key: tracts_towns2000_pkey

Somehow you managed to create your table with all uppercase column
names. So you have to keep double quoting these names.

> grass=> SELECT conv.tract_id, tr.tract FROM tracts_towns2000 conv,
> tracts2000 tr LIMIT 5;
> ERROR: No such attribute or function 'tract_id'

SELECT conv."TRACT_ID", tr.tract FROM tracts_towns2000 conv,
tracts2000 tr LIMIT 5;

BTW, unless one of these tables has only one row, you almost certainly
want to add a WHERE clause to your query, something like

WHERE tr.thiscolumn = conv.thatcolumn

Servus
Manfred