title: group by all columns from one table
body: <p>I have a simple query:</p>
  
  <pre><code>select c.* , max(TLO.BILL_DATE)
  from
  
  client c
  left outer join TLORDER TLO
  on TLO.CUSTOMER = c.CLIENT_ID
  OR TLO.ORIGIN = c.CLIENT_ID
  OR TLO.DESTINATION = c.CLIENT_ID
  
  GROUP BY c.*
  </code></pre>
  
  <p>The query itself is pretty straightforward however the client table contains over 200 fields and I need to retrieve them all.</p>
  
  <p>is there a way to do something like</p>
  
  <pre><code>GROUP BY c.*
  </code></pre>
  
  <p>or do I have to type all 200+ GROUP_BY?</p>
  
  <p>Thank you</p>