create table master1
(
ID1 int primary key,
sal1 int
)
create table master2
(
ID2 int primary key,
sal2 int
)
i would like to know how we will write SQl Query for creating fact table that will contain
foreign keys(id1,id2) and metric values (sal1,sal2,bal,bal2) from both the tables