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?