/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 vote296 views1 answer
10000000000000000000 am to meters
SQL
1 vote313 views1 answer
Mysql copy table1 to table2
SQL
6 votes292 views1 answer
Oracle trigger after connect
SQL
12 votes305 views4 answers
Mysql version query
SQL
7 votes334 views2 answers
Where keyword sql
SQL
0 vote338 views1 answer
Load data infile mariadb slow
SQL
0 vote320 views2 answers
Postgres having
SQL
0 vote293 views1 answer
Soql more than today
SQL
0 vote322 views1 answer
Sparql if bound query
SQL
2 votes312 views4 answers
Duplicate record mysql
SQL