/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

1 vote177 views1 answer
How to update date add hours in postgresql
SQL
1 vote317 views1 answer
Athena query timestamp greater than
SQL
0 vote183 views1 answer
List in one column mysql
SQL
0 vote181 views1 answer
Print mysql
SQL
0 vote128 views1 answer
Finish transaction sql
SQL
1 vote170 views1 answer
Mysql select month and year
SQL
2 votes181 views1 answer
Postgresql update sequence next value
SQL
0 vote184 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote164 views1 answer
Remove binlog mysql
SQL
0 vote165 views1 answer
Mssql describe stored procedure sqlcmd
SQL