Tutorials

Web Development

Bootstrap CSS HTML JavaScript jQuery Node.js PHP React TypeScript

Programming

C C#C++Go Java Python Rust

Data and Databases

NumPy Pandas SQL

Tools

Projects

Project: A Tiny Shell in C Project: Bank Account System Project: Library Management System Project: Portfolio Page Project: Quiz App in React Project: Sales Data Analysis Project: Server Log Analyser Project: To-Do REST API Project: URL Shortener Project: Word Counter in Four Languages

All tutorials ❯

Paths References

Practice

Try it editor Quizzes How To recipes Tools Glossary

Home › References › SQL Reference

❮ INNER JOIN CROSS JOIN ❯

LEFT JOIN

All rows from the left table, matched where possible.

Type: Join

Syntax

FROM a LEFT JOIN b ON ...

Example

Examplesql

Open in editor »

← All of SQL Reference