title: Trying to get the primary Keys of the first two table to autopo
body: <p>I have Tables , A,B,C. In table A I have an identity (1,1) primary Key and also in table B. Tables A and B are both strangers.</p>
  <p>Table C is a Join Table that have 3 columns:</p>
  <ol>
  <li><p>A primary Key (INT) no constraints</p>
  </li>
  <li><p>B primary Key (INT) no constraints</p>
  </li>
  <li><p>C value (date)</p>
  </li>
  </ol>
  <p>1 an 2 have references as FK_1 (PK_1) and FK_2 (PK_2). I want if i run a query all the values of A,B,C a retrieved. The value of C was added using transact sql only inputing. No value for A and B as they already have value.</p>
  <p>Currently output shows null for A and B. Only value for C appears.</p>
  <p>How can I fix this?</p>