Connect 2 Fields?

[#1]

Hi Dears;

I would like to as follows :

Table1:
a,
b,
c,
d;

Table2:
i as a,
x,
y,
z,
if(b=x,y);

May i use resident and how? Or How can i do it?

Thanks
Best Regards...

[Miguel_Angel_Baeyens]

Hello,

Try the following:

Table1:a,b,c,d;Table2:i as a,x,y,z,WHERE EXISTS(b, x) OR EXISTS(b, y);

Hope that helps.

[#3]

Hi;

I have 2 different tables from same database.

Is it true for this ?


Thans in advance...

[Miguel_Angel_Baeyens]

Hello,

Yes, since it works with already loaded data (first pull frorm the data source, then loads into memory only those who match).

Regards.