JOINING 2 tables but not all columns

Discussion created by tangopapa on Mar 4, 2013
Latest reply on Mar 5, 2013 by tangopapa

I can't seem to figure out if this is possible:

I have 2 tables A, B

A has x number of columns
B has y number of columns

I want to join B to A on a common value.  This I can easily do.  However, I only want to join only a subset of columns from B to a and not all the data... Is there a quick of doing this?  (I can now do a join on both and then manually remove the columns I don't want, but this is rather tedious).  Any suggestions would be welcomed!