Submit for review

SQL & Database Management: Joins: Combining Tables

Send your work to our team for review. If it is approved you earn up to 10 points.

Answer the Check yourself questions in your own words.

1. When do you use LEFT JOIN instead of JOIN? 2. Why does `COUNT(o.id)` differ from `COUNT(*)` after a LEFT JOIN? 3. How do you find rows with no matching row in another table? Notes (optional)

Who is submitting? With my name and email (I confirm it by a link and the points count for me)

Your name Email

Show my first name and points on the leaderboard Anonymously (logged by IP address, no points kept for you)

We store what you send and your name and email, or your IP address if you stay anonymous. IP addresses are deleted after 90 days. Privacy Policy

PandaDev

Services

App Catalogue

Learn

Company

Help

Change language

Submit for review