title: SQL join with composite primary key
body: <p>I have to join two tables.
  But in one table primary key is not there,composite primary key is there,means three columns put together uniquely define a row of that table.
  I have those three columns in the other table too.rest nothing is common.
  Is there any way to join these two tables.please explain with the help of example</p>