Hi. If there is some syntax to make nice looking tables, please point me to instructions on how to do it.

Suppose I have a table like this
key | field1| field2 fieldA
--------------------------- ---------
a | 1 | AA a
b | 3 | CF and one like this c
c | 1 | QB a
d | 2 | JV b
-------------------------- b

How can I "select" a table like the second one, but with two more columns populated with the corresponding field1 and field2 values pulled from the first table?