Create New Data based on 2 initial table

[POWER_MI]

In power Project there are two table 

Table Base_1 couloumn Home ( H1,H2,H3), Student ( S1,S1,S1,...)

Table Base_2 Action ( A1,A2,A3), Room(R1,R1,R1), Student( S1,S2,S3...)

The objectif is to have SQL or Dax commande to :

Create new table 3 based on two imported one and the condition is : 

When for example on Base_1 The Home=H1 the New table base_3 will be with Value of Base_2 /  Student=S1  because on Base_1 when Home =H1 Student=S1 so will take on Base_2 value Student=1 and other data Action A1...

Table Base_1 

Home                Student 

H1                      S1

H2                      S2 

H3                      S3

Table Base_2 

Action ( A1,A2,A3

Room(R1,R1,R1

Student( S1,S2,S3

[lbendlin]

I assume there will be multiple actions per student, and the 1:1 relationship you show ins not supported with larger data sets? Please provide more realistic sample data in usable format and show the expected outcome.