SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign ke
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign ke

Problem solved.
I Read carefully the link
https://editor.datatables.net/examples/simple/join.html
This discussion has been closed.