[SOLVED] join key

RapidEndUser
RapidEndUser New Altair Community Member
edited November 5 in Community Q&A
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.
Tagged:

Answers

  • earmijo
    earmijo New Altair Community Member
    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".
  • RapidEndUser
    RapidEndUser New Altair Community Member
    Thank you.
    I found it after experiment the operator.

    -RapidEndUser.

Categories