User Profile
mabond12
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
SQL query for concatenating field value of two records
Hello, I have a table with records of individuals (a surname and a forename field for each) with unique id's for each individual. Each record also has a field with a value for a family id. In cases where two individuals are married or partners they will have the same family id but different surnames, forenames and person-id's. I want my query to be able to select the two records with the matching family-id's and give me a single record result with the forenames and surnames concatenated in a single field so we get a result like "Joe Bloggs and Wilma Flintstone". Thanks and regards Michael Bond496Views0likes1Comment
Recent Blog Articles
No content to show