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}