Flag if Value exists in another table

[Anonymous]

Hi,

I have two tables in my sql server, Table A and Table B. I am creating a qvw/qvd file and pulling Table A in it. I want to create a Flag field to identify which of the values of a field called ID were existing in Table B. I do not have to necessarily pull in data from Table B.

I just need a Flag to identify the ones that existed and the ones that didn't exist.

Could anyone please suggest how to do it.

Thank You.

[marcus_sommer]

You could try something like this:

B: load distinct ID from B;

A: load *, -exists(ID) as Flag from A;

drop tables B;

- Marcus

[Sergey_Shuklin · Accepted solution]

Hello!

You can use join for achieving this

[Anonymous]

Worked perfectly fine for me.

Thank You.

[Anonymous]

Hi,

Thank you for your response.

I had tried a similar solution but couldn't get the right numbers.