Using NATURAL JOIN, you can save yourself some typing and make queries a little clearer. This kind of join takes two tables and automatically joins columns that have the same name.
SELECT name,author,title FROM customers NATURAL JOIN classics;
Using NATURAL JOIN, you can save yourself some typing and make queries a little clearer. This kind of join takes two tables and automatically joins columns that have the same name.
SELECT name,author,title FROM customers NATURAL JOIN classics;