cancel
Showing results for 
Search instead for 
Did you mean: 

Join tables in sq02

Former Member
0 Kudos

Hi

How can I create a <b>one to one</b> join (not one record to many records) between 2 tables in sq02 ?

thanks,

Itzhak

Accepted Solutions (0)

Answers (1)

Answers (1)

VXLozano
Active Contributor
0 Kudos

Using primary keys in both tables... you will get only that join if your tables are related 1:1

If you can do it with ABAP, just use

SELECT a~* FROM a INNER JOIN b ON ...

And then LOOP AT a doing a SELECT SINGLE * FROM b WHERE (join conditions).

Almost is what I believe...

Best wishes,

Vic