Combine multiple rows into one row

Combine multiple rows into one row

I'm trying different JOIN queries, but I'm not getting result I'm looking
for.
I've got 2 tables:
Table 1: **StockItemShort**
ItemID | Code | Name
432724 | CK002-16-09 | Green Daisy Pearl Earrings
432759 | CK002-16-149 | Emerald Crystal Centre Daisy Earrings
Table 2: **StockItemCatSearchValueShort**
ItemID | SearchValueID
432724 | 388839
432724 | 389061
432724 | 390269
432724 | 389214
432759 | 388839
432759 | 389051
432759 | 390269
432759 | 389214
I can't get result I'm looking for.
I'd like to get following result:
ItemID | Code | Name | SearchValueID | SearchValueID | SearchValueID |
SearchValueID
432724 | CK002-16-09 | Green Daisy Pearl Earrings | 388839 |
389061 | 390269 | 389214
432759 | CK002-16-149 | Emerald Crystal Centre Daisy Earrings | 388839
| 389051 | 390269 | 389214