Join two tables

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi,

COSP>COEP>COBK

|

CSKS-->CSKT

[Former Member]

Hi,

Using these tables u need to link the tables

[Former Member]

hi prince,

can u explain it?

i didn't get the idea.

[Former Member]

HI

check link between

COSP-OBJNR = CSKS--OBJNR

fetch corresponding csks-kostl as per your requirement.

Reward if its helpfull

Regards.

Jay