hi, I have made really simple tables but when calling them some error occurs, let me explain:
I have made one simple table named "Classics" with 5 books, including authors, title, year and isbn and i have made another table called "customers" including name,title and isbn.
to problem:
I link these together and want to call them but does not work i do this as following:
select name,author,title,isbn from customers,classics where customers.isbn=classics.isbn;
does not run
but when i do as follwing it does run:
select name,author,title from customers,classics where customers.isbn=classics.isbn;
why does it not run together with isbn?
error code: "Column 'isbn' in field list is ambiguous"
I have made one simple table named "Classics" with 5 books, including authors, title, year and isbn and i have made another table called "customers" including name,title and isbn.
to problem:
I link these together and want to call them but does not work i do this as following:
select name,author,title,isbn from customers,classics where customers.isbn=classics.isbn;
does not run
but when i do as follwing it does run:
select name,author,title from customers,classics where customers.isbn=classics.isbn;
why does it not run together with isbn?
error code: "Column 'isbn' in field list is ambiguous"