/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 vote204 views1 answer
See Foreign Key
SQL
0 vote177 views2 answers
Spring properties file for db
SQL
0 vote234 views1 answer
Show specific events on mysql
SQL
3 votes190 views1 answer
Insert into table from another table mysql
SQL
6 votes195 views2 answers
WHERE value IS sql
SQL
0 vote213 views2 answers
Sql trigger difference between for and after
SQL
0 vote212 views1 answer
Oracle cpu metric
SQL
1 vote205 views1 answer
Sql server update column based on another table
SQL
2 votes291 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote256 views1 answer
Sql query to select even numbers
SQL