SQL-complete-tutorial
11 строк · 274.0 Байт
1USE sql_store;
2
3SELECT
4o.order_id,
5c.first_name
6FROM orders o
7NATURAL JOIN customers c;
8
9-- With NATURAL JOINs, we let the database guess the natural
10-- connection between two tables. It is known to give an unexpected
11-- results, so it's advised to be used carefully.