Home>

MySQL -How to merge two tables without duplicates?

I have two tables:

I need to dine these tables and output so that it turns out

when I display them with code

SELECT * FROM comment
RIGHT JOIN comment_answer ON comment.ID= comment_answer.id_comments
ORDER BY comment.id DESC

I get something like this:

This is already on the client, so form the output, and now everything comes from the database as it should.

u_mulder2022-01-28 20:30:12

how can this be implemented?

Самуэль Арутюнян2022-01-27 21:20:48
mysql mysqli