/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 vote141 views1 answer
View psql output in horizontal scrolling
SQL
0 vote146 views1 answer
Alter column to not null with default value sql server
SQL
22 votes166 views1 answer
Mysql workbench
SQL
1 vote123 views1 answer
Importance of comment in mysql
SQL
0 vote136 views1 answer
Python mysql show databases
SQL
2 votes148 views4 answers
2nd highest salary in mysql
SQL
0 vote97 views1 answer
Java spring jdbc connect to postgresql
SQL
1 vote133 views1 answer
Oracle lowercase
SQL
23 votes155 views4 answers
Uninstall postgresql ubuntu
SQL
1 vote139 views1 answer
Oracle turn off constraint
SQL