/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 vote198 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote192 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote305 views1 answer
Multiple row join
SQL
0 vote181 views1 answer
Postgres float to int
SQL
0 vote168 views1 answer
Postgresql inline table
SQL
0 vote196 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote201 views1 answer
Create table split string function in sql server
SQL
0 vote191 views1 answer
Mysql_error replacement
SQL
0 vote196 views1 answer
Plsql check for string in numeric
SQL
1 vote190 views1 answer
Oracle case
SQL