Ok, I have 1 table containing partnumbers "tbl_parts" and another table containing seperate serialnumbers "tbl_serials" of each part. (1-N)
Using 1 SQL statement I'd like to get this result:
PartNumber Nomenclaute SerialNumbers
abcdef somepart 001,002,003
Is this possible, I basically want to create a field with the serialnumbers in list format, grouping on partnumber.