query two tables using same lookup table - Mailing list pgsql-sql

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.