Natural Join Explanation
<p>I am a student trying to learn Microsoft SQL and I am frustrated that I cannot understand how natural join works. I have a problem with a solution but I cannot understand how this solution was created through natural join. My friend sent my his old solution but cant remember how he got the result. I really want to figure out how this natural join works. Can someone please explain how this answer was achieved?</p>

<p>The question taken from "Database Design, Application, and Administration 6th Ed.:</p>

<ol start="12">
<li>Show the result of a natural join that combines the Customer and OrderTbl tables.</li>
</ol>

<p><img src="https://i.stack.imgur.com/B4yb0.png" alt="Tables"></p>

<p><img src="https://i.stack.imgur.com/76zZq.png" alt="Solution"></p>

<p>Edit: The book doesn't give a query statement on how to get the results for the natural join in the chapters I have read so far. Which makes things much more confusing for me as I cannot simply add the table and send a query.</p>

<p>Edit2: The reason why some entries in the order table have null values is because the question is implying that some orders were processed through the internet. A friend of mine told me that was the reason why he got the question right opposed to some people who argued against it. :S</p>