On Jul 22, 2012, at 23:04, ssylla wrote:
> 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
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 out
