get rows from 1 table with other table empty mysql

Solutions on MaxInterview for get rows from 1 table with other table empty mysql by the best coders in the world

showing results for - "get rows from 1 table with other table empty mysql"
Hiba
31 Jul 2017
1SELECT students.name, students.lastname, ifnull(courses.course_name, '-') as course_name
2FROM students
3LEFT JOIN courses
4ON courses.id_student=students.id_student 
5WHERE students.name LIKE '%$search%'
6GROUP BY students.id_student 
7ORDER BY students.name, students.lastname, courses.course_name
8
similar questions