Copy link to clipboard
We are using CF10. I am writing a query that feeds into an adobe report builder report. Several tables are involved.
I need the name, address, and the checklist items on one row. There can be up to 3 checklist items per name, one name, one address.
The data looks something like this
The output should look like this:
Joe Student 123 Main HI PD
Sam Student 123 Main JP
Anne Student 123 Main HI JP
Have something to add?