Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Return 0/1 if a unique value is found in another column.

Hello!

 

I want to do a test to see if a ID appears in another table that is a subest of the data. 

 

So for example:

3   1   0

4   2   0

5   3   1

     5   1

     6   0

 

I feel like there might be a easy soultion to do, but just can't find anything online! 

 

Thanks!

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    You could achieve it by merging tables.

    LEFT OUTER JOIN

    Expand the column.

    Add a conditional column.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    You could achieve it by merging tables.

    LEFT OUTER JOIN

    Expand the column.

    Add a conditional column.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.