/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 vote247 views1 answer
Convert rows into columns in oracle
SQL
0 vote203 views1 answer
Mysql into outfile with headers
SQL
0 vote186 views1 answer
Oracle current timestamp insert statement
SQL
0 vote175 views1 answer
Check connections to database postgres
SQL
21 votes187 views1 answer
SQL cheat sheet pdf
SQL
15 votes185 views2 answers
How to drop database name in postgresql
SQL
0 vote213 views1 answer
Remove mysql from centos 7
SQL
0 vote187 views1 answer
Postgres populate table from another table
SQL
0 vote200 views1 answer
Oracle sql drop table
SQL
0 vote195 views1 answer
Mysql url data type
SQL