title: Attempting to use a SUB-SELECT within logparser to retrieve folder information
body: <p>My end goal is to return data using log parser in a table similar to this</p>
  
  <pre>PATH      QTY       SIZE(KB)
  C:\Path\dir     1200         150223</pre>
  
  <p>I can picture the query in my mind but I think I am missing something. (It's probably obvious). Here is my query as I have now:</p>
  
  <pre><code>C:\scripts&gt;logparser -i:fs "SELECT f.* FROM (SELECT path FROM C:\DOWNLOADS\*.* WHERE ATTRIBUTES LIKE 'D%') f"
  </code></pre>
  
  <p>I receive this error: "Error: Syntax Error: : expecting FROM keyword instead of token '*'"</p>
  
  <p>If I change my code a bit to the following, I get another curious error...</p>
  
  <pre><code>C:\scripts&gt;logparser -i:fs "SELECT * FROM (SELECT path FROM C:\DOWNLOADS\*.* WHERE ATTRIBUTES LIKE 'D%')"
  </code></pre>
  
  <p>The error I receive is: "Cannot open : Error searching for files in folder  C:\scripts(SELECT path FROM C:\DOWNLOADS: The filename, directory name, or volume label syntax is incorrect.</p>
  
  <p>I'd like to return the size of the different sub directories below the c:\downloads path. I would adjust the wildcards to further narrow my results.</p>
  
  <p>EDIT - More info
  I am hoping to return data from a structure similar to this:</p>
  
  <pre>
  TopFolder
  |_SubFolder
  | |_SubSubFolder1
  | |_SubSubFolder2
  | |_SubSubFolder3
  |_OtherFolder
  </pre>
  
  <p>Return a table or some form of data like this:</p>
  
  <pre>
  _FolderName___Qty____AvgSize____MaxSize____MinSize
  SubSubFolder1  250    334533      45000     445
  SubSubFolder2  123     4443       2233      344
  ....
  </pre>