title: LEFT JOIN on table.* as alias?
body: <p>How can i simply return a left join's column values as a separate key in a query?</p>
  
  <pre><code>SELECT meta.*
       , post.* as venue
       , venue_meta.* as venue_meta
    FROM $wpdb-&gt;postmeta as meta
    LEFT 
    JOIN $wpdb-&gt;posts as post 
      ON meta.meta_key = '_EventVenueID' 
     AND meta.meta_value = post.id
    LEFT 
    JOIN $wpdb-&gt;postmeta as venue_meta 
      ON venue_meta.post_id = venue.id
   WHERE meta.post_id = %d
   GROUP 
      BY meta.meta_id
  </code></pre>
  
  <p>So i'm expecting all the columns in the post table to return as $response['venue'], but I have a syntax error on the first line.</p>