Can I Join a File By Columns

March 23, 2006, 11:21 AM

What I am asking is when you execute a Join, the field you join on is placed in the same row.

JOIN ID IN EMPINFO TO
ID IN DEPINFO AS J1
END

Table would look like this:

ID Name ID Name
12 Harry 12 Shiela

Is there a way to do a Join or a Match where the output would look like this:

ID Name
12 Harry
12 Shiela

And if they also have additional field columns that do not match, just have them append to the table columns, like normal match's do?

Thank you for your assistance!

Scott

March 24, 2006, 04:25 PM

slfmr

Is the yyyy the other Hold File Name?

Would it be:

TABLE FILE Hold1Name
Print
---
---
MORE Hold2Name
---
---
END

Thank you for your help!

Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6

March 24, 2006, 05:25 PM

TexasStingray

  
TABLE FILE CAR
PRINT
COUNTRY
ON TABLE HOLD AS HOLD1
MORE
FILE CAR
END

TABLE FILE HOLD1
PRINT *
BY COUNTRY
END

This does not JOIN the files it merges them

Scott

March 26, 2006, 08:08 AM

<JG>

First I would like to say that your join would never produce the results that you describe.
Second if you have multiple names associated with the same id and a single key then your system will never work correctly, because it is totally incorrect to have multiple names in a DBMS associated with a single key which is/should usually be a unique multiple key.

However cicumstances exist where for example you have FAMILY NAME, FAMILY MEMBER (2 KEYS are required) but you are using only one as a sort in your request.

In the circumstances that you are looking at, even if you only have 1 key and multiple rows then

1) JOIN ID IN A TO ALL ID IN B (for the join)
2) PRINT X Y Z
BY ID
BY NAME (for the sort)

Will resole your problem

This really is a basic and fundamental issue of any system not just WebFocus.

The forum is a place where those of us using Focus/WebFocus freely give help and advice
but in this case I really do suggest that you request that your employer pay for you to have some basic
training from a competent person.

This message has been edited. Last edited by: <JG>,

March 30, 2006, 02:29 PM

slfmr

Thank you Texas Stingray... a merge is what I had more in mind. This has helped me!

Umm okay, thank you JG (I think). I was just asking a question, I don't think insults are necessary.

If you were going to just do that, I would have rather you not replied to my post.

Thank you all for your help. I apologize if my questions are too "basic." I too thought that "the forum is a place where those of us using Focus/WebFocus freely give help and advice."

This message has been edited. Last edited by: slfmr,

Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6