[SOLVED] join key

RapidEndUser

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.

earmijo

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".