Hello, and thank you for your answer.

Here is the modified query with qualified tables and columns :

SELECT r.r_t_id, tg.a_value

FROM rank r

INNER JOIN topic tp on r.r_t_id =...