/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 vote184 views1 answer
Database schema for mcqs type exam in sql
SQL
14 votes202 views2 answers
Oracle add attribute to table
SQL
0 vote168 views1 answer
Oracle list index on table
SQL
0 vote331 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote178 views1 answer
Can we rollback deleted data in sql
SQL
6 votes181 views1 answer
Postgresql add enum value
SQL
0 vote195 views1 answer
Add sqlcmd to path linux
SQL
0 vote241 views2 answers
Uninstall postgresql mac
SQL
0 vote200 views1 answer
Create query in where clasue
SQL
0 vote196 views1 answer
How to combine first and last nae into one columb sql
SQL