title: SQL: Select all values from one table in a join while not knowing all column names?
body: <p>Hello there I wonder if the following is possible (in MySQL): There is a simple query joining two tables:</p>
  
  <pre><code>SELECT * FROM `contact_attending_appointment` AS tcon,`contact` AS tget WHERE tcon.appointment_id = 2 AND tget.id = tcon.contact_id;
  </code></pre>
  
  <p>This query will return the values of both tables - tcon and tget - joined together. However, I want only to have the columns of ONE table.</p>
  
  <p>Basically in SQL you achieve it like this:</p>
  
  <pre><code>SELECT col_1,col_2,...,col_n FROM ...
  </code></pre>
  
  <p>Or you get all the columns with</p>
  
  <pre><code>SELECT * FROM ...
  </code></pre>
  
  <p>However I would like to have something like (as I do not know the columns of tget by their names)</p>
  
  <pre><code>SELECT [* from tget] FROM ...
  </code></pre>
  
  <p>Is there a general solution for this or is this not possible?</p>