By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Table1 (`id` INTEGER, `account` VARCHAR(5), `type` VARCHAR(2), `date` DATETIME);
INSERT INTO Table1 (`id`, `account`, `type`, `date`) VALUES
('1', '234w', 'R', '2020-01-01'),
('2', '567', 'FD', '2020-05-07'),
('3', '678gh', 'FD', '2020-09-10');
CREATE TABLE Table2 (`id` INTEGER, `designation` VARCHAR(8));
INSERT INTO Table2 (`id`, `designation`) VALUES
('2', 'customer'),
('3', 'employee'),
('3', 'manager');
CREATE TABLE Table3 (`id` INTEGER, `state` VARCHAR(2));
INSERT INTO Table3 (`id`, `state`) VALUES
('1', 'UP'),
('2', 'AP'),
('3', 'UK');
SELECT MAX(CONCAT(account,"/",type,"/",date)) AS col1,
GROUP_CONCAT(t2.designation SEPARATOR "/") AS col2,
GROUP_CONCAT(DISTINCT t3.state SEPARATOR "/") AS col3
FROM Table1 t1
LEFT JOIN Table2 t2 ON t1.id=t2.id
LEFT JOIN Table3 t3 ON t1.id=t3.id
GROUP BY t1.id
| col1 | col2 | col3 |
|---|---|---|
| 234w/R/2020-01-01 00:00:00 | null | UP |
| 567/FD/2020-05-07 00:00:00 | customer | AP |
| 678gh/FD/2020-09-10 00:00:00 | employee/manager | UK |