/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

2 votes37 views2 answers
Convert_tz mysql
SQL
0 vote34 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote32 views1 answer
Product of a column in mysql
SQL
0 vote71 views1 answer
SQL-Arten
SQL
0 vote24 views1 answer
Ora 00001 error catch plsql
SQL
0 vote30 views1 answer
Postgresql combine values in one field
SQL
4 votes30 views3 answers
Postgres drop all tables
SQL
12 votes36 views6 answers
Select distinct
SQL
0 vote26 views1 answer
Can we rollback deleted data in sql
SQL
0 vote31 views1 answer
Proc sql not in working
SQL