/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

21 votes132 views6 answers
Docker run mysql
SQL
0 vote133 views1 answer
Download mysql database to excel in android studio
SQL
0 vote190 views1 answer
Postgres rename database
SQL
3 votes222 views4 answers
Sql interview questions
SQL
1 vote134 views1 answer
Type int in mysql maxlenght
SQL
0 vote134 views1 answer
Sql query for displaying age from oldest to youngest
SQL
5 votes121 views1 answer
Mysql add user with all privileges
SQL
1 vote89 views1 answer
How to run sql script
SQL
7 votes127 views6 answers
Nth highest salary in sql
SQL
0 vote137 views1 answer
TSQL function split string
SQL