WayneZ

While each mem_id has only one ref_id, that doesn't mean there is only one mem_id for each ref_id. Someone could have referred more than one member so several mem_id values could be linked to the same ref_id. Also, if a member has no ref_ID value, how do you know what …

I don't believe you can concatenate the values from the same column in several records into a single value in a single SQL statement, at least not one that someone who is not an expert in SQL could create. If you want to investigate further I suggest searching the internet …

One way to accomplish this is to create another table that gives the relationship between bug and patch records. It would hold the respective ID values, that is, which bug was addressed by which patch. An ID value could appear in as many records as needed. You could then start …