title: Select Data From Two Tables SQL
body: <p>I have one Table (SeekerInfo) that like :</p>
  
  <pre><code>--------------------------------------------------
  SeekerID -  SeekerName - SeekerSex - SeekerMobile
  12121    -  mmmm       - Male      - 067676767
  13223    -  ssss       - Female    - 078876767
  --------------------------------------------------
  </code></pre>
  
  <p>and another table (SeekerCources) that like (every seeker maximum have 3 cources): </p>
  
  <pre><code>--------------------------------------------------
  SeekerID - CourceName - Duration
  12121    - MCSA       - 1 year
  12121    - MCPD       - 6 months
  13223    - CCNA       - 1 year
  13223    - CCNP       - 1 year
  13223    - MCTS       - 4 months
  </code></pre>
  
  <p>I want to make a select statement that preview data from two Tables look like this:</p>
  
  <pre><code>SeekerID -  SeekerName - SeekerSex - SeekerMobile - Cource1 - Cource2 - Cource3
  12121    -  mmmm       - Male      - 067676767    - MCSA    - MCPD    - *NULL*
  13223    -  ssss       - Female    - 078876767    - CCNA    - CCNP    - MCTS 
  </code></pre>