multiple relationship

[#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_Tiers'
ISNULL ((SELECT FROM TA.TBL_LIB TABLES WHERE YOUR TA.TBL_ID = 'FC2' AND TA.TBL_CODE T.FC2_CODE =), '') AS 'C2_Tiers'

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: Tiers TABLE
TA: Tables TABLE