On 03/02/2016 13:11, arnaud gaboury wrote:

> Hum hum...
> ------------------------------------------------------
> SELECT u.username ||'@'||d.domain as email_address
> FROM email.mailusers u
> INNER JOIN
> email.domain d
> ON
> (u.domain_id=d.domain.id)
> WHERE id=1;
> 
> ERROR:  missing FROM-clause entry for table "domain"
> LINE 6: (u.domain_id=d.domain.id)
> --------------------------------------------------------------
> 
> What did I wrong following your solution?

In the join condition, replace "d.domain.id" with "d.id" (partly my
mistake, I missed that the column is called "id" and not "domain_id" in
the domains table).

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to