Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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.
Hi;
I have 2 different tables from same database.
Is it true for this ?
Thans in advance...
Hello,
Yes, since it works with already loaded data (first pull frorm the data source, then loads into memory only those who match).
Regards.