i trying generate report normalized database tables a, a_xref_b, , b. create table (a_rid int primary key, a1 varchar(20), ); create table b (b_rid int primary key, b1 varchar(20), b2 varchar(20)); create table a_xref_b (a_rid int, b_rid int,xref_type int constraint fk_a foreign key (a_rid) references (a_rid), constraint fk_b foreign key (b_rid) references b (b_rid)); insert values (1,'john'), (2,'sue') insert b values (1,'atlanta','ga'), (2,'macon','ga'), (3,'opp','al') insert a_xref_b values (1,1,1), (1,2,2), (2,3,1) table , b cross-referenced , have cross reference has type, defines data in b represents. scenario - john provided main city , alternate. sue provided main city. i trying write view load page has name, main city, , alternate. name b_rid_t1 city_t1 st_1 b_rid_2 city_t2 st_t2 john 1 atlanta ga 2 macon ga sue 3 opp al null null nu...