How to compare two columns different tables?

[#1]

How do I compare two different columns, and results table create a column with YES or NO.

Eg compare between table 1 and table 2 if the user is equal to another, if not inform NOT.

LOAD

[oknotsen · Accepted solution]

I am not sure I understand what you are trying to achieve.

If you only want to load data from a table of which the key already is in memory, you could try something like this:

TableA:

Load SomeKey

FROM SomeSource

;

TableB:

Load DifferentKey

FROM SomeOtherSource

WHERE EXISTS (SomeKey, DifferentKey)

;

Or are you trying to do some comparison in the front-end? If so, it again depends on what you are exactly trying to achieve. There are solutions with Set Analysis and with Alternate State, but it depends on your data.

So....

Did my example solve your problem?

If not:

Can you supply us with some more explanation of your problem? Can you supply some demo data?

[#3]

Yes, resolved.

Thank  you.