Newbies to webfocus. I need to joint two table together.
Table 1
K 05 key-01
k 05 key-02
k 05 key-03
05 data-01
05 data-02
05 data-03
05 data-04
Table 2
K 05 t2-key-01
K 05 t2-key-02
k 05 t2-key-03
k 05 t2-key-04
k 05 t2-key-05
05 t2-data-01
05 t2-data-02
05 t2-data-03
joint condition:
key-01 = t2-key-01
key-02 = t2-key-03
data-02 = t2-key-05
t2-key-02 = 'C'
t2-key-04 = 'SR'
so I can get a report like
K 05 key-01
k 05 key-02
k 05 key-03
05 data-01
05 data-02
05 t2-data-02
Thanks..
Table 1
K 05 key-01
k 05 key-02
k 05 key-03
05 data-01
05 data-02
05 data-03
05 data-04
Table 2
K 05 t2-key-01
K 05 t2-key-02
k 05 t2-key-03
k 05 t2-key-04
k 05 t2-key-05
05 t2-data-01
05 t2-data-02
05 t2-data-03
joint condition:
key-01 = t2-key-01
key-02 = t2-key-03
data-02 = t2-key-05
t2-key-02 = 'C'
t2-key-04 = 'SR'
so I can get a report like
K 05 key-01
k 05 key-02
k 05 key-03
05 data-01
05 data-02
05 t2-data-02
Thanks..