/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

14 votes104 views5 answers
Set password for postgres user ubuntu
SQL
8 votes106 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote100 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote108 views1 answer
Set a value by excuting stored procedure
SQL
4 votes107 views1 answer
Mysql not equal
SQL
0 vote144 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote107 views1 answer
Oracle archivemode
SQL
0 vote112 views1 answer
Distance calculator from lat long sql query
SQL
0 vote57 views1 answer
Get last run query sql server
SQL
3 votes106 views3 answers
Update join
SQL