/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 votes133 views1 answer
Get ddl materialized view oracle
SQL
0 vote168 views1 answer
Day of the week sqlite
SQL
1 vote131 views1 answer
How to find median of a column sql
SQL
0 vote148 views2 answers
Return the number of records in a single table mysql
SQL
24 votes142 views4 answers
Mssql get all table names
SQL
23 votes140 views4 answers
Sql server substring
SQL
0 vote145 views1 answer
Create table split string function in sql server
SQL
0 vote139 views1 answer
Sql select most frequent value in column
SQL
25 votes151 views5 answers
Uninstall mysql ubuntu
SQL
3 votes165 views3 answers
Order by postgres
SQL