Skip to content

Predict LEFT JOIN Rows

Predict Output Medium
workbench

Question

Table A has 5 rows, table B has 3 rows. All B rows match A rows. How many rows from LEFT JOIN?

Code

                  SELECT COUNT(*) FROM A LEFT JOIN B ON A.id = B.a_id;
                

Related Resources

Related Lessons

Look up unfamiliar terms

A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.

View glossary

Decode error messages

Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.

View errors

Build real projects

Apply what you learned by building guided projects with starter code and solutions.

View projects

← Back to topic