Query multiple tables using JOIN operation

1)Retrieve the details of dependent table of Fname on who is depending on
and his name.

 

SQL> select fname,essn,dependent_name
2 from employee,dependent
3 where ssn=essn;
FNAME ESSN DEPENDENT_NAME
-------------------- -------------------- --------------
Varun 0236 yash
prjwal 4126 indrita
Thilak 7894 diganth
pranav 0662 radhika

 

2) Retrieve book_id,branch_id,no_of_copies of a book in ascending order of
authors name.

 

SQL> select author_name,A.book_id,branch_id,no_copies
2 from book_authors A,book_copies B
3 where A.book_id=b.book_id
4 order by author_name;
AUTHOR_NAME BOOK_ID BRANCH_ID NO_COPIES
--------------- ---------- -------------------- ----------
KUVEMPU BOOKID01 BRNCHID01 1400
Krishna BOOKID05 BRNCHID05 365
Lakshmi BOOKID04 BRNCHID04 254
Ramesh BOOKID03 BRNCHID02 800
Tagore BOOKID02 BRNCHID03 100