You need to create a query that selects 2 fields in each database table. I do not understand how it can be done and whether it can be done at all, since it only comes to mind to manually list the fields and the necessary tables.

The task is taken from the exam: enter image description here

UPD: Tables: enter image description here enter image description here enter image description here enter image description here enter image description here enter image description here enter image description here

Of course, I understand that knowing the names of the tables and their fields, you can simply list them in the SELECT, but I'm not sure that this is what is required by the task. I just want to know if it is possible to get the table fields by a query without knowing their names? And is it possible to get all tables from a database with a query?

  • one
    any two fields? The first two fields? Two fields that are in each table? - Zufir
  • Give examples of tables and the expected conclusion - cpp questions

0