9 lines
191 B
MySQL
9 lines
191 B
MySQL
|
SELECT
|
||
|
|
s.name,
|
||
|
|
s.city,
|
||
|
|
cl.name AS manager,
|
||
|
|
cl.fi AS managerFi
|
||
|
|
FROM company c
|
||
|
|
JOIN supplier s ON s.id = c.id
|
||
|
|
JOIN client cl ON cl.id = c.workerManagerFk
|
||
|
|
WHERE c.id = ?
|