/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

2 votes162 views1 answer
How to delete view in sql
SQL
-1 vote171 views1 answer
Search all sql tables for a value
SQL
1 vote165 views1 answer
Sql server kill all connections
SQL
0 vote198 views1 answer
Doctors appointment
SQL
1 vote177 views3 answers
Read all columns of a table sql
SQL
0 vote166 views1 answer
Hashpass
SQL
3 votes166 views2 answers
Mysql create database
SQL
-1 vote172 views2 answers
Postgresql get last 10 records
SQL
0 vote183 views2 answers
How to count codition
SQL
1 vote159 views1 answer
Sql comment header
SQL