title: SQL - Table Join and Pivot Query
body: <p>I need some advice. I'm trying to join two tables, but one has multiple rows for each academic course -- and I need all values for specific col's to be displayed after the join. I think this will include a pivot -- but that is a function I am unfamiliar with and I can't seem to get it to work. Here are the details. The join would be on Year_Code, Term_Code, and Course_Code.</p>
  <p>Table1 = Course_List</p>
  <ul>
  <li>YEAR_CODE / TERM_CODE / COURSE_CODE</li>
  <li>1920    /   SP      / Math_100</li>
  <li>1920    /   SP      / Engl_100</li>
  </ul>
  <p>Table2 = Inst_Load</p>
  <ul>
  <li>YEAR_CODE / TERM_CODE / COURSE_CODE / Instructor_ID / Load_Percent</li>
  <li>1920    /   SP      / Math_100    /  0012         /  100</li>
  <li>1920    /   SP      / Engl_100    /  0099         /  75</li>
  <li>1920    /   SP      / Engl_100    /  0088         /  25</li>
  </ul>
  <p>Output</p>
  <ul>
  <li>Year_Code / Term_Code / Course_Code / Inst1_ID / Inst1_Load_PCT /Inst2_ID / Inst2_Load_PCT</li>
  <li>1920      /   SP      /   Math_100   /   0012  /         100</li>
  <li>1920      /   SP      /   Engl_100   /   0099  /         75     /   0088 /    25</li>
  </ul>
  <p>If possible, sort the selection of instructor load by highest percentage first? That would be nice too.</p>
  <p>I appreciate the help. Trying to get a working code for this run. I'm having trouble wrapping my head around this one. Cheers!</p>