One field (tab1) in relation to several fields (tab2)

[#1]

HI,

I have a slightly complex question.
I have a field in relation to two other fields in the same table.
as in the following example:

ISNULL ((SELECT FROM TA.TBL_LIB TABLES WHERE YOUR TA.TBL_ID = 'FC1' AND TA.TBL_CODE T.FC1_CODE =), '') AS C1 Third '
ISNULL ((SELECT FROM TA.TBL_LIB TABLES WHERE YOUR TA.TBL_ID = 'FC2' AND TA.TBL_CODE T.FC2_CODE =), '') AS C2 Third '

TBL_ID is in relation with the field FC1_CODE and is also related to the field FC2_CODE.

How to realize this relationship in Qlikview?

How to translate this SQL query?

T: THIRD TABLE
TA: TABLES TABLE