Options

[SOLVED] join key

RapidEndUserRapidEndUser Member Posts: 10 Contributor II
edited November 2018 in Help
Hi Rapid-I Support,

How can I join 2 tables using a key id?
I can see “join” operator but this shows just “inner”, “left”, ”right” and ”outer” joins but I don't see where can I join a field between two tables.
I am looking for an operator to join a field from table1 and a field from table2?

Thanks,
RapidEndUser.

Answers

  • Options
    earmijoearmijo Member Posts: 270 Unicorn
    Provide a simple example.

    The JOIN operatior joins two tables using the IDs of both tables as key. If you want to use another field. You uncheck 'use id attribute as key' and you define the attributes to use pressing "Edit List".
  • Options
    RapidEndUserRapidEndUser Member Posts: 10 Contributor II
    Thank you.
    I found it after experiment the operator.

    -RapidEndUser.
Sign In or Register to comment.