topic Re: Join two tables in Application Development and Automation Discussions

Join two tables

Former Member — Tue, 03 Jun 2008 12:07:48 GMT

hi experts,

I have an internal tables. it fetches

values from 2 tables : cosp and csks.

i need to use csks-kostl in my report.

how can I join these two tables. There is

no common key.

Re: Join two tables

Former Member — Tue, 03 Jun 2008 12:15:03 GMT

Hi,

You need to have a common field between 2 tables if you want to put a join between them.

Or otherwise,

Find the check table of the primary keys of the tables.

Try to find the common fields from one of the check tables of the primary keys.

Example,

If you want to join tables A and B.

Both tables don't contain common fields.

A has primary key fields X and Y.

go to check table of X or Y.

Let check table of X is C.

check any field in C which are exist in table B.

Join tables A and C.

Based on this pick the data from B.

Reward if helpful

Regards,

preet

Re: Join two tables

Former Member — Tue, 03 Jun 2008 12:32:03 GMT

Hi,

COSP~~>COEP~~>COBK

CSKS-->CSKT

Re: Join two tables

Former Member — Tue, 03 Jun 2008 12:32:49 GMT

Hi,

Using these tables u need to link the tables

Re: Join two tables

Former Member — Tue, 03 Jun 2008 12:38:29 GMT

hi prince,

can u explain it?

i didn't get the idea.

Re: Join two tables

Former Member — Tue, 03 Jun 2008 12:43:15 GMT

check link between

COSP-OBJNR = CSKS--OBJNR

fetch corresponding csks-kostl as per your requirement.

Reward if its helpfull

Regards.

Jay