In the access database, have a table, how can now generated by as shown in table 1 table 2
/

CodePudding user response:

Where is god?

CodePudding user response:

Select name, A phone from table
Union all
Select name, telephone from table B
Union all
Select name, telephone C from table
.

CodePudding user response:

refer to the second floor xiajinxian response:

select name, A telephone from table
Union all
Select name, telephone from table B
Union all
Select name, telephone C from table
.

At the far right that how to display the column of figures?

CodePudding user response:

Select name, 'A' phone, A telephone from table
Union all
Select name, 'phone B, the phone from table B