I have two tables, one with various details such as
Username, email id, user code
and another table with columns which are:
UserCode, supervisor email id, active_flag
I required an output of a table which only displays the active users i.e. the users with
N) column as 'Y'.
So as of now I have
Inner Joined these two tables on
UserCode as it exists in both and my table now looks like:
|Username| Email ID | SuperVisor Email ID| |Dan | [email protected] | [email protected] | |John | [email protected] | [email protected] |
Is there a way that I can check from one of my tables the data from the column
ACTIVE_FLAG and only display the active (
Y) user details into this Inner Joined table?
I have searched on stack overflow but couldn't find a solution which I could use.