title: MYSQL - select TABLE A rows that are not in Table B except the rows are in TABLE C
body: <p>TABLE A:</p>
  <blockquote>
  <p>dvdID.......dvdTitle</p>
  <p>d01..........Avenger</p>
  <p>d02..........Avenger</p>
  <p>d03..........Spiderman</p>
  </blockquote>
  <p>TABLE B:</p>
  <blockquote>
  <p>rentID.......dvdID</p>
  <p>r01...........d01</p>
  <p>r02...........d02</p>
  <p>r03...........d03</p>
  </blockquote>
  <p>TABLE C:</p>
  <blockquote>
  <p>returnID.......rentID</p>
  <p>t01...............r01</p>
  </blockquote>
  <p>i want to select dvd that not in Table B (rented) except it in Table C (returned)
  so the output should be like this:</p>
  <p>OUTPUT:</p>
  <blockquote>
  <p>dvdID.......dvdTitle</p>
  <p>d01..........Avenger</p>
  </blockquote>
  <p>could you help me?</p>