/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 votes127 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote126 views2 answers
Php convert dbf to mysql
SQL
1 vote115 views1 answer
Does insert into overwrite sql
SQL
1 vote133 views3 answers
Postgresql crete view
SQL
2 votes115 views6 answers
Mysql change timezone
SQL
16 votes114 views4 answers
Ascending order mysql
SQL
0 vote111 views2 answers
Mysql decimal remove trailing zeros
SQL
11 votes110 views1 answer
Sql query to find duplicates in column
SQL
0 vote121 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote111 views1 answer
Mysql bash execute sql file
SQL