sql - 'ORA-00918: column ambiguously defined'如何解决

Question

问题:。对于从“Branch_C”分支借出且到期日期为是 2013 年 4 月 2 日，检索书名、借款人姓名和借款人姓名地址。

我的回答::

select TITTLE , NAME, ADDRESS 
    from BOOK B , BORROWER O, BOOK_LOANS L  
    where B.BOOKID= L.BOOKID and L.BRANCHID = 
        (select BRANCHID from LIBRARY_BRANCH where BRANCHNAME='Branch_C')
        and (O.CRADNO=L.CRADNO) and L.DUE_DATE='2013-2-13'  

我有这个错误

ORA-00918: column ambiguously defined

Answer 1

你应该定义列属于哪个表

select B.TITTLE , O.NAME, L.ADDRESS 
    from BOOK B , BORROWER O, BOOK_LOANS L  
    where B.BOOKID= L.BOOKID and L.BRANCHID = 
        (select BRANCHID from LIBRARY_BRANCH where BRANCHNAME='Branch_C')
        and (O.CRADNO=L.CRADNO) and L.DUE_DATE='2013-2-13'