Hi Guys,
I've been working on this all day and can't seem to figure it out. Your help is greatly appreciated.
Current SQL query is returning data that looks like this:
ID FNAME LNAME FLDTEXT FLDTEXT_ID (HIDDEN)
1 JOHN DOE BLUE 10
1 JOHN DOE RED 11
1 JOHN DOE GREEN 12
Which is fine, however the Word Mail Merge receipient list wants to treat all of these as seperate and individual records, which is the problem.
I need it to look something like this:
ID FNAME LNAME FLDTEXT FLDTEXT1 FLDTEXT2 FLDTEXT_ID (HIDDEN)
1 JOHN DOE BLUE RED GREEN 10, 11, 12
Unfortuantely, I do not have direct access to the source, so I can modify the table structure. Based on my research, I need to create a SQL view and use UNION function. Any guidance would be greatly appreciated.
I've been working on this all day and can't seem to figure it out. Your help is greatly appreciated.
Current SQL query is returning data that looks like this:
ID FNAME LNAME FLDTEXT FLDTEXT_ID (HIDDEN)
1 JOHN DOE BLUE 10
1 JOHN DOE RED 11
1 JOHN DOE GREEN 12
Which is fine, however the Word Mail Merge receipient list wants to treat all of these as seperate and individual records, which is the problem.
I need it to look something like this:
ID FNAME LNAME FLDTEXT FLDTEXT1 FLDTEXT2 FLDTEXT_ID (HIDDEN)
1 JOHN DOE BLUE RED GREEN 10, 11, 12
Unfortuantely, I do not have direct access to the source, so I can modify the table structure. Based on my research, I need to create a SQL view and use UNION function. Any guidance would be greatly appreciated.
