Hi,
I need to form a query where i can add some columns based on the result.
Table A
ColA, ColB
----------
1 A
2 B
3 A
Table B
ColC
----
A
If A exists if would like the result back as
1 A OK
2 B NG
3 A OK
Is it possible to replace the value in the query ?
Thanks
Alex