newbies - how to joint two table's together?

[jackyzsn]

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..

 

[focwizard]

What type of files are these? If relational, then you can do a multi-field JOIN. OTW, there are other things to do.

 

[jackyzsn]

Thanks. I think I got it work.