SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Visits   ([ADATE] date, [AKEYTIME] varchar(10), [ATIME] varchar(10), [BOOK] varchar(10), [ID] varchar(100), [ACCOUNT] int,
                       [ADESC] varchar(100), [DEPARTMENT] varchar(100), [FINTIME] varchar (10), [FACILITY] varchar(10), [APPTNO] int);
CREATE TABLE CustList ([ACCOUNT] int, [FAMILY] int, [CLNAME] varchar(100), [CFNAME] varchar(100), [CMNAME] varchar(100), [CPHONE] varchar(12),
                       [CID] int, [SEX] varchar(1), [NICKNAME] varchar(100), [EMAIL] varchar(100));
CREATE TABLE Orders   ([ID] int, [DATETIME] datetime, [SSNO] int, [NAME] varchar(100), [ORDERDATE] date, [ORDERTIME] varchar(10),
                       [DONEDATE] date, [DONETIME] varchar(10), [PAGE] int, [ACCOUNT] int, [FACILITY] varchar(100));

INSERT INTO Visits
    ([ADATE], [AKEYTIME], [ATIME], [BOOK], [ID], [ACCOUNT], [ADESC], [DEPARTMENT], [FINTIME], [FACILITY], [APPTNO])
VALUES
    ('', '11:18', '11:18 AM', 'HD1_WC', 'SMITH, JOHN', '131456', 'REPAIR ORDER', 'HD', '11:35 AM', '', '2002467341'),
    ('', '15:21', '03:21 PM', 'XA1_NU', 'JONES, JANE', '343789', 'NEW PURCHASE', 'XA', '3:35 PM', '', '2002763299'),
    ('', '15:30', '03:30 PM', 'XA1_NU', 'JONES, JANE', '343789', 'NEW PURCHASE', 'XA', '3:35 PM', '', '2002763244')

INSERT INTO CustList
    ([ACCOUNT], [FAMILY], [CLNAME], [CFNAME], [CMNAME], [CPHONE], [CID], [SEX], [NICKNAME], [EMAIL])
VALUES
    ('131456', '131456', 'SMITH', 'JOHN', '', '111/222-3333', '131456', 'M', 'JOHN', 'JOHN@EMAIL.COM'),
    ('343789', '343789', 'JONES', 'JANE', '', '111/444-5555', '343789', 'F', 'JANIE', 'JANE@EMAIL.COM')

INSERT INTO Orders
    ([ID], [DATETIME], [SSNO], [NAME], [ORDERDATE], [ORDERTIME], [DONEDATE], [DONETIME], [PAGE], [ACCOUNT], [FACILITY])
VALUES
    ('0001457843', '', '343789', 'JONES, JANE', '', '03:35 PM', '', '', '2002763299', '343789', 'OFFICE 1'),
    ('0001457844', '', '343789', 'JONES, JANE', '', '03:35 PM', '', '', '2002763299', '343789', 'OFFICE 1'),
    ('0001457845', '', '343789', 'JONES, JANE', '', '03:35 PM', '', '', '2002763244', '343789', 'OFFICE 1'),
    ('0001457846', '', '343789', 'JONES, JANE', '', '03:35 PM', '', '', '2002763244', '343789', 'OFFICE 1'),
    ('0001237789', '', '131456', 'SMITH, JOHN', '', '11:35 AM', '', '', '2002467341', '131456', 'OFFICE 2'),
    ('0001237790', '', '131456', 'SMITH, JOHN', '', '11:35 AM', '', '', '2002467341', '131456', 'OFFICE 2')
;

11 rows affected

Account	Email	Facility
343789	JANE@EMAIL.COM	OFFICE 1
343789	JANE@EMAIL.COM	OFFICE 1
343789	JANE@EMAIL.COM	OFFICE 1
343789	JANE@EMAIL.COM	OFFICE 1
131456	JOHN@EMAIL.COM	OFFICE 2
131456	JOHN@EMAIL.COM	OFFICE 2