/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 vote105 views1 answer
Apt install sql server
SQL
-1 vote100 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
10 votes111 views3 answers
How to fetch first 5 characters in sql
SQL
1 vote109 views3 answers
String to int mysql
SQL
0 vote97 views1 answer
Sql last 7 days
SQL
0 vote100 views1 answer
Sql grant select only
SQL
0 vote105 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
8 votes114 views1 answer
Oracle search stored procedures for text
SQL
5 votes111 views2 answers
Postgresql insert select
SQL
0 vote102 views1 answer
Mysql events not work
SQL