Joining two output tables in ONE table

[PradeepBondla]

Hi All,

I have 1 read query and 1 bapi... I need to show the output of these two into a table.

EXAMPLE:

Query returns 2 columns FIRST NAME and ID NUMBER.

Bapi returns 2 columns LAST NAME and ID NUMBER.

now table should show 3 columns like FIRST NAME.....LAST NAME...... ID NUMBER.

FIRST NAME is from Query....LAST NAME is from bapi.... where ID NUMBER is same.

Fname 1(from Query)           Lname 1 (from Bapi)               id 1(matching in both Query and Bapi)

Fname 2(from Query)           Lname 2 (from Bapi)               id 2(matching in both Query and Bapi)

In other words.... when ID NUMBER is same in query and bapi those record should come in single line.

Thanks,

PradeeP

Note: Right now I am using UNION operator which is showing both the results line by line....

USING UNION OPERATOR, RESULT IS.....

Fname1                                           id 1

Fname 2                                          id 2

                       Lname1                    id 1

                       Lanem2                     id 2

DESIRED RESULT...

Fname 1           Lname 1                id 1

Fname2            Lname 2               id 2

same question raised in forum but no correct answers. its not possible in VC 7.1?????

I am thinking it is not possible after reading below threads.... please share your thoughts.....

[PradeepBondla]

not possible

[former_member341000]

Hi,

VC doesn't have a join operator, so it can't be done just with VC.

Instead, you should create a service that receives the 2 tables and performs the join, and consume the service in VC.

Best regards,

Tal.