Dear list, assuming I have two tables as follows
t1: id_project|id_auth 1|1 2|2 t2: id_project|id_auth 1|2 2|1 and a lookup-table: t3 id_auth|name_auth 1|name1 2|name2 Now I want to query t1 an t2 using the 'name_auth' column of lookup-table t3, so that I get the following output: id_project|name_auth_t1|name_auth_t2 1|name1|name2 2|name2|name1 Any ideas? Thanks- Stefan -- View this message in context: http://postgresql.1045698.n5.nabble.com/query-two-tables-using-same-lookup-table-tp5717583.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql