PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE USERS (ID text, USERID text, EMAIL text);
INSERT INTO USERS VALUES('1','XD4555','JOHNE@DEO.COM');
INSERT INTO USERS VALUES('2','JJKKKK','JANE@DEO.COM');
INSERT INTO USERS VALUES('3','JJKKKK','JANE21@DEO.COM');
CREATE TABLE FUSERS (ID text, USERID text, USERID_IM text);
INSERT INTO FUSERS VALUES('1','XD4555','JJKKKK');
INSERT INTO FUSERS VALUES('2','JJKKKK','TYYUPPO');
COMMIT;
{ user1 => [], user2 => [["JANE21\@DEO.COM"], ["JANE\@DEO.COM"]] }
{ TotalEmails => [["JANE21\@DEO.COM"], ["JANE\@DEO.COM"]] }
JANE21@DEO.COM
JANE@DEO.COM