Joining Tables - Access DB


I need your help writing a query where a column from one Table is inserted into another Table as a row. Both these tables doesn't have any column names in common.

Table 1 -

UAT Phase---Q2---Q3---Q4---Q1

Table 2 -


So, I just want to use The_Percentage column from Table 2 and insert it into Table 1 as a row; so that the final table looks like this (I have added this row in the image manually to picturize) -


Any help would be really appreciated.

Thank you

Keshav Birla

Please provide:

  • table definitions in the form of create statements
  • sample data in the form of insert statements