/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

11 votes239 views1 answer
Oracle view source
SQL
0 vote201 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote198 views1 answer
Mysql bash execute sql file
SQL
0 vote207 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
22 votes266 views4 answers
Date format mysql
SQL
12 votes191 views2 answers
Insert multiple rows from another table sql
SQL
0 vote216 views1 answer
Mysql insert into select with recursive
SQL
10 votes167 views2 answers
Sql where clause multiple values
SQL
2 votes208 views3 answers
How to check current user in mySQL
SQL
2 votes207 views1 answer
Guid to string sql
SQL