title: How to get multiple columns value from all the tables in SQL
body: <p>I am trying to get the column values from all the tables, I have some tables which contain group_name and date and so far, I need only the group_name and date values from all the tables</p>
  <p><strong>Table 1</strong></p>
  <p><a href="https://i.stack.imgur.com/k7cdn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/k7cdn.png" alt="enter image description here" /></a></p>
  <p><strong>Table 2</strong></p>
  <p><a href="https://i.stack.imgur.com/N45jG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N45jG.png" alt="enter image description here" /></a></p>
  <p>Here is my query (query is returning nothing)</p>
  <pre><code>select table_name
  from information_schema.columns
  where column_name = 'group_name' AND column_name = 'date'
  </code></pre>
  <p>so the output should be something like this</p>
  <p><a href="https://i.stack.imgur.com/XTNzW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XTNzW.png" alt="enter image description here" /></a></p>
  <p>Note: I don't want to specify the table names because there will be many tables. I have shown only two and table names are dynamic and can be deleted or created from the frontend</p>