/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 vote314 views1 answer
Mysql convert charset
SQL
0 vote274 views1 answer
List column names of multiple tables psql
SQL
0 vote258 views1 answer
Sql query for getting data with join and count
SQL
1 vote260 views1 answer
Sql delete all values in a column
SQL
6 votes310 views2 answers
Subtr Oracle ?
SQL
0 vote277 views1 answer
C# add a textbox in mysql select
SQL
0 vote308 views1 answer
Pgadmin check database
SQL
0 vote243 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote301 views1 answer
Python mysql show databases
SQL
0 vote267 views1 answer
View to table
SQL