how to add to the right side of my table, the colums and data of 2 other tables . [message #662636] |
Mon, 08 May 2017 09:07 |
mpniel
Messages: 4 Registered: February 2007
|
Junior Member |
|
|
Is it possible with a select statement, to add to the right side of table A , the colums and data of 2 other tables B and C .
Example:
table A: col1 (pk) , col2 -- 10 rows
table B: col3 (pk) , col4 -- 10 rows
table C: col5 (pk) , col6 -- 10 rows
Each table have all pk values that exist on the other 2 tables.
the result should be as follows:
table A: col1 (pk) , col 2 , col4, col6
|
|
|
|
|
|
|
|