/SQL/Get rows from 1 table with other table empty mysql

Get rows from 1 table with other table empty mysql

SELECT students.name, students.lastname, ifnull(courses.course_name, '-') as course_name
FROM students
LEFT JOIN courses
ON courses.id_student=students.id_student 
WHERE students.name LIKE '%$search%'
GROUP BY students.id_student 
ORDER BY students.name, students.lastname, courses.course_name

Source: stackoverflow.com

Similar codes

0 vote418 views1 answer
Sqlite display data in separated columns
SQL
0 vote308 views1 answer
Sql max min
SQL
0 vote362 views1 answer
Dynamic where clause in sql server stored procedure
SQL
12 votes315 views1 answer
Docker run mysql image
SQL
6 votes319 views1 answer
What is where clause in sql
SQL
0 vote334 views1 answer
Test the postgresql db connection
SQL
0 vote354 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote312 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote315 views1 answer
Kill thread
SQL
2 votes321 views1 answer
Oracle list grants on procedure
SQL