If you wish to specify the column on which to join two tables, use the JOIN…ON construct:
SELECT name,author,title FROM customers
JOIN classics ON customers.isbn=classics.isbn;
If you wish to specify the column on which to join two tables, use the JOIN…ON construct:
SELECT name,author,title FROM customers
JOIN classics ON customers.isbn=classics.isbn;