You’re missing the whole subquery to concatenate the rows.
if your SQL version is 2019+ then try this as a calculated field
string_agg(PartBin.BinNum, ' ,');
and group by the other fields in the query.
You’re missing the whole subquery to concatenate the rows.
if your SQL version is 2019+ then try this as a calculated field
string_agg(PartBin.BinNum, ' ,');
and group by the other fields in the query.