[Solved] If I have two columns, how can I select all distinct values of columnA where columnB is never a specific value given that columnA is the same value?

by

[ad_1]

If I have two columns, how can I select all distinct values of columnA where columnB is never a specific value given that columnA is the same value?

[ad_2]

solved If I have two columns, how can I select all distinct values of columnA where columnB is never a specific value given that columnA is the same value?