/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

4 votes325 views6 answers
Select sql
SQL
4 votes284 views2 answers
Oracle sql group by date year
SQL
4 votes300 views3 answers
Sql drop primary key
SQL
0 vote261 views1 answer
Postgresql get current user name
SQL
0 vote416 views1 answer
Sql developer export connections
SQL
4 votes301 views1 answer
Conda install sqlalchemy
SQL
1 vote287 views2 answers
Logical operators in sql
SQL
0 vote314 views1 answer
Mysql case when on date
SQL
0 vote266 views1 answer
Mysql events not work
SQL
8 votes300 views1 answer
Oracle add datafile to tablespace
SQL