recursive case in sql

Question

i have a conflict in the insert statement with the foreign key of the same table . the problem occurs while the insert :

my table is such : staffs (staff_id, name,phone, manager_id)

and the manager_id is a foreign key that references staffs( staff_id)

Answer 1

That's really to less on information. How does your SQL look like?

Please post table design as DDL, some sample data as DML statement and the expected result.

Answer 2

Please post table design as DDL, some sample data as DML statement and the expected result.