SQL Find "Manage" name List using m_id

SELECT m2.name as Name, m1.name as Mag FROM manager as m1 RIGHT OUTER JOIN manager as m2 ON m1.id = m2.m_id
---------------------------------------------------------------------


-----------------------------------------------------------------------



-----


CREATE VIEW `t1` AS SELECT m2.name
 FROM manager as m1
LEFT OUTER JOIN manager as m2
ON m1.id = m2.m_id

SELECT m2.name as Name, m1.name
 as Mag FROM manager as m1
RIGHT OUTER JOIN manager as m2

ON m1.id = m2.m_id



http://www.dofactory.com/sql/left-outer-join

https://www.tutorialspoint.com/sql/sql-inner-joins.htm


https://www.guru99.com/views.html



https://stackoverflow.com/questions/32522604/compare-rows-and-columns-of-same-table

https://stackoverflow.com/questions/15899022/sql-column-compare-in-the-same-table-self-join

SELECT
*
FROM
tbl
WHERE
category = 'b'
AND value NOT IN (SELECT value FROM tbl WHERE category = 'a')