I have 2 different tables that have no relation between them. I just want to compare 2 column from each of those and tell if the values in one column are there in the other (basically compare the values in both)
Is there a way this can be achieved? NB - There is no relation between these two tables.
There probably is a way. Even if the tables are not associated the fields values would be associated (as if) as in cross-join case. You could get the values something like:
=Concat(Distinct if(Field1<>Field2,F1), ',') // to get the comma separated values in a textbox
There probably is a way. Even if the tables are not associated the fields values would be associated (as if) as in cross-join case. You could get the values something like:
=Concat(Distinct if(Field1<>Field2,F1), ',') // to get the comma separated values in a textbox
Actually, this halts my qvw, maybe this is too ram intensive. As a workaround, I've tried left join. Let's see, I'll post here if I get an other alternative.
