Hi Frnds,
I have 3 tables :-
1) Section Access:
NTNAME, Flag
'1' as Flag
2) Custom Directory:
NTNAME, Flag
'2' as Flag
3) MySingle Table:
NTNAME, Flag
'3' as Flag
Provided Dummy Data.
I need to find those :-
a) users which exists in mysingle table & not in Section Access,Custom Directory
b) users which exists in Section Access & not in mysingle table,Custom Directory
c) users which exists in Custom Directory & not in mysingle table,Section Access