SQVI: Joining Different Field Names

[Former Member]

Hey all,

Is it possible to join two fields that are not of the exact same technical name?

We are trying to join tables KSSK and WLK1. We want to link the assortment (FILIA in WLK1) to the assortment object (OBJEK in KSSK).

Would this be possible?

Thank you,

Ryan

[former_member583013]

The technical name is not important...What matters is the type and length of the fields...In you case a CHAR 10 against a CHAR 50 should not work...

Greetings,

Blag.

[Former Member]

Thanks Alvaro... any fancy solution you can think of to join this data together? Or are we stuck with excel/access to make it work?

[former_member583013]

Well...WLK1 is empty on my system, so it's hard to tell...

Maybe I will do it like this...Select data from KSSK first, and the LOOP it taking only 10 characters from field OBJEK...For each iteration of the LOOP I will do a SELECT SINGLE of WLK1...If there's no data, then that registry should be gone...and so on...

Of course, not the best solution...But can't seem to find anything else...

Greetings,

Blag.