Joining Tables - Access DB

Hello

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
XYZ---xyz---xyz---xyz---xyz

Table 2 -

Quarter---Bandwidth---Hours---The_Percentage
xyz---xyz---xyz---xyz---xy%

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) -

image

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