Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

newbies - how to joint two table's together?

Status
Not open for further replies.

jackyzsn

Programmer
May 17, 2007
14
CA
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..
 
What type of files are these? If relational, then you can do a multi-field JOIN. OTW, there are other things to do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top