tom22london
Programmer
how can i find title of book whcih have the same publisher 'tom', but i am not supposed to include 'tom' in my output.
following are the tables,
Borrower (bor_id, bor_name, bor_maxbooks)
Book_title (bt_id, bt_name,pub_id, value)
Book_copy (bc_id, bt_id*, date acquired)
Loan (bor_id, bc_id, date_out, date_due, date_back)
Publisher (pub_id, pub_name, pub_address)
Author (author_id, author_name)
Authorship (author_id, bt_id)
--------------------------------------------
following are the tables,
Borrower (bor_id, bor_name, bor_maxbooks)
Book_title (bt_id, bt_name,pub_id, value)
Book_copy (bc_id, bt_id*, date acquired)
Loan (bor_id, bc_id, date_out, date_due, date_back)
Publisher (pub_id, pub_name, pub_address)
Author (author_id, author_name)
Authorship (author_id, bt_id)
--------------------------------------------