title: Need help to fix my inner join SQL statement and C# code
body: <p>I have 2 tables, what I am looking for is:</p>
  
  <p><code>JobApplic</code> table contains:</p>
  
  <pre><code>ApplicNum, 
  JobNum, 
  UID "this is the employer", 
  Jobtitle, 
  AplicUID " this is job seeker" 
  </code></pre>
  
  <p><code>CVs</code> table contains:</p>
  
  <pre><code>CVNum, 
  UID (here in this table is the job seeker) , 
  FN, 
  LN, 
  etc.... 
  </code></pre>
  
  <p>The statement it something like that but I am not so professional to write in the correct way:</p>
  
  <pre><code>select 
  from [JobApplic] ApplicNum, JobNum, UID, Jobtitle, AplicUID 
  where 
       UID 
  into table JobApplic = session["UsrNme"], 
  inner join table [CVs] UID,FN, LN, ... 
  Where UID into table CVs = ApplicUID into table JobApplic"    
  </code></pre>
  
  <p>The mean point from this code is when employer enter to his account he will be able to see all applicant CV's whose applied for jobs which posted by the employer. </p>
  
  <pre><code>protected void ViewapplCV_Click(object sender, EventArgs e)
  {
      if (Session["UsrNme"] != null)
      {
          using (SqlConnection AppCVsSQLCon = new SqlConnection(sc))
          {
              AppCVsSQLCon.Open();
  
              SqlDataAdapter ApplCVsDAADP = new SqlDataAdapter(@"
                 SELECT AD.[ApplicNum], AD.[JobNum], AD.[UID], AD.[Jobtitle],
                        AD.[AplicUID], UI.[UID], UI.[FN], UI.[LN] 
                 FROM [JobApplic] AS AD JOIN CVs AS UI ON AD.[UID] = UI.[UID] 
                 WHERE AD.UID = @UID AND AD.AplicUID = UI.UID", sc);
  
              var use = Session["UsrNme"];
  
              ApplCVsDAADP.SelectCommand.Parameters.AddWithValue("@UID", use);
  
              DataSet dsApplCVs = new DataSet();
  
              ApplCVsDAADP.Fill(dsApplCVs);
  
              showapplicforemployrLV.DataSource = dsApplCVs.Tables[0];
              showapplicforemployrLV.DataBind();
          }
      }
      else
      {
          // Your Session key could not be found, consider displaying an error
      }
  
      MultiView1.ActiveViewIndex = 12;
  }
  </code></pre>