I have two tables as follows:

Table 1:

PCID          DESC             DIM1          DIM2          LEN_FT          LEN_IN
A123            W               10             12              40              0
A124            W               10             12              35              6
etc...


Table 2:

PCID          BCID                         LOC
A123          cIV333334                   A1
A123          cIV333335                   A1
A123          cIV333336                   B1
A124          cIV333337                   C1
A124          cIV333338                   D1
A124          cIV333339                   E1
etc...

I am looking for the following result:

PCID          DESC             DIM1          DIM2          LEN_FT          LEN_IN      LOC
A123            W               10             12             40               0        A1, B1
A124            W               10             12             35               6        C1,D1,E1
etc...

Is this possible using sql?

Thanks in advance,