title: How to get a certain value from an associative table in sql
body: <p>I have two tables and one table that associates these two.
  Table A has two columns (pk,name)
  Table B also has two columns (id,name)
  Table AB has three columns (pk(FK of A), id(FK of B), date)</p>
  
  <p>How can I write a select to retrieve A.name, B.name and AB.date
  for a certain A.pk?</p>