Hi, I have a table which stores 2 values as follow
REC_TEST
Id_Customer
Id_Apply
Id_Apply can take 2 values, "YES" or "NO" if he passes the test I've designed or not. I want to know if there is a way to take all "YES" and all "NO" from the same table, for example:
Id_Customer[YES] | Id_Customer[NO]
-------------------------------------------------------
203974 | 3284755
.....
and so on...
I've been trying wiht somethin like doing:
SELECT Id_Customer As YES, Id_Customer As NO
FROM REC_TEST
WHERE YES = 'YES'
AND NO = 'NO';
this is obviusly wrong, can you help me get it?
Thank you guys.