title: How to solve 'ORA-00918: column ambiguously defined'
body: <p>Question :. For each book that is loaned out from the "Branch_C" branch and whose DueDate
  is 02-Apr-13, retrieve the book title, the borrower's name, and the borrower's
  address.</p>
  
  <p>my answer ::</p>
  
  <pre><code>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'  
  </code></pre>
  
  <p>l have this error </p>
  
  <blockquote>
    <p>ORA-00918: column ambiguously defined </p>
  </blockquote>