MYSQL How to get unique values from two tables mysql

I’m trying to get unique Value from two tables but the problem is the data in ‘d.feedback’ is displaying all of the data in the column feedback from daily_report table. This is the code that i Use. So what do you think should i do? Distinct fullname and feedback? or is there another alternative. Here is the question i ask in stackoverflow

https://stackoverflow.com/questions/66333609/mysql-how-to-get-unique-values-from-two-tables-mysql

SET @row := 0; SELECT DISTINCT CONCAT(@row := @row + 1,' ',ui.firstname, ' ', ui.mname, ' ', ui.lastname, ' in ' ) as 'Regular Users', d.feedback FROM daily_report d INNER JOIN userinfo ui ON d.userid = ui.id 

submitted by /u/GORILLA_BYTE
[link] [comments]


Go to Source of this post
Author Of this post: /u/GORILLA_BYTE
Title Of post: MYSQL How to get unique values from two tables mysql
Author Link: {authorlink}