Join tables in sq02

[Former Member]

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

[VXLozano]

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