Applications.ge

USING

If the fields names that we want to join are the same, we can use

USING

keyword

SELECT 
    students.first_name, 
    notes.*
FROM `students` 
LEFT JOIN notes USING(student_id)

The alternative of the above query using

ON

clause:

SELECT 
    students.first_name, 
    notes.*
FROM `students` 
LEFT JOIN notes ON notes.student_id = students.student_id

by Valeri Tandilashvili

MySQL

USING

MySQL Tutorial for Beginners

Pro tip: use ```triple backticks around text``` to write in code fences