title: SQL Query pulling extra data
body: <p>I am using this query in SOAPUI against our SOAP API. </p>
  
  <pre><code>&lt;soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:del="http://tempuri.org/Deltek.Vision.WebServiceAPI.Server/DeltekVisionOpenAPIWebService"&gt;
     &lt;soapenv:Header/&gt;
     &lt;soapenv:Body&gt;
        &lt;del:GetProjectsByQuery&gt;
           &lt;!--Optional:--&gt;
           &lt;del:ConnInfoXML&gt;&lt;![CDATA[&lt;VisionConnInfo&gt; 
                &lt;databaseDescription&gt;Description&lt;/databaseDescription&gt; 
                &lt;userName&gt;USERNAME&lt;/userName&gt;
                &lt;userPassword&gt;PASSWORD&lt;/userPassword&gt;
                &lt;integratedSecurity&gt;Y&lt;/integratedSecurity&gt; 
              &lt;/VisionConnInfo&gt;]]&gt;&lt;/del:ConnInfoXML&gt;
           &lt;!--Optional:--&gt;
           &lt;del:Query&gt;SELECT WBS1,Name,Principal FROM PR WHERE PR.WBS1='H15032.00'&lt;/del:Query&gt;
           &lt;!--Optional:--&gt;
           &lt;del:RecordDetail&gt;'Project'&lt;/del:RecordDetail&gt;
        &lt;/del:GetProjectsByQuery&gt;
     &lt;/soapenv:Body&gt;
  &lt;/soapenv:Envelope&gt;
  </code></pre>
  
  <p>The request goes through and gives me a response, however it gives me additional fields also. I just want to pull the column specified in query itself like WBS1, Name, and Principal fields only.</p>
  
  <pre><code>&lt;WBS1&gt;H15032.00&lt;/WBS1&gt; 
  &lt;Name&gt;Name&lt;/Name&gt; 
  &lt;Principal&gt;Principal Name&lt;/Principal&gt;
  &lt;custLetterofIntent&gt;Y&lt;/custLetterofIntent&gt;
  &lt;custIssued&gt;2015-06-03T00:00:00.000&lt;/c‌​ustIssued&gt;
  &lt;CreateUser&gt;KGOODENOW&lt;/CreateUser&gt;
  &lt;CreateDate&gt;2015-06-03T15:51:20.913&lt;/‌​CreateDate&gt;
  &lt;ModUser&gt;KGOODENOW&lt;/ModUser&gt;
  &lt;ModDate&gt;2015-06-03T15:52:29.227&lt;/ModDate&gt;‌​
  &lt;CustContractStatus&gt;LOI&lt;/CustContractStatus&gt;
  &lt;/ROW&gt;
  &lt;/Projects_ConsultantAgreements‌​&gt;
  &lt;/REC&gt;
  &lt;/RECS&gt;]]&gt;
  &lt;/GetProjectsByQueryResult&gt;
  </code></pre>
  
  <p>Am I missing something?</p>