选择相关的元素属性作为字符串

I have an items Table and a Tags table. Now what I would like is to have one Select that gets Items under a certain condition and for each item selects the related tags and puts them in a string to become a seperate field.I have an items Table and a Tags table. Now wha