📜 ⬆️ ⬇️

There are two requests. Data is taken from a single table. How can I display two queries in one, only the field names must be different

Select first_name as Служащий from Customers Where first_name='JOHN' Select first_name as Коллеги, department_id from Employee Where department_id=(Select department_id from Employee Where first_name='JOHN' ) AND first_name<>(Select first_name from Employee Where first_name='JOHN' )

UNION is not suitable. I need the table to look like: Employee, Colleagues, Department ID

Akina

15.1k one ten 29

Non- non-

one one

And what about “colleagues” in what form, if there are several? I suspect that join and some kind of listagg replacement, such as stackoverflow.com/questions/15477743/listagg-in-sqlserver - Mike
just last names. some. - Nedoprogrammer

|

1 answer 1

 SELECT t1.first_name, t2.department_id, GROUP_CONCAT(t3.first_name) FROM Customers t1, Employee t2, Customers t3 WHERE /* t1.first_name='JOHN' AND */ t1.department_id = t2.department_id AND t2.department_id = t3.department_id AND t1.first_name != t3.first_name GROUP BY t1.first_name

If you need only for one JOHN-a - uncomment the condition, but remove the grouping.

Akina

15.1k one ten 29

there is a sql-server in which there is no group_concat - Mike
Well link through XML, business ... - Akina

|

Source: https://ru.stackoverflow.com/questions/833445/

All Articles