I have a foreign key of "Travel_ID" in this table, as each "Travel" can have multiple visits.
I need to pull a summary that takes the min date, max date, and lists all employees related.
I have the first part:
Select Min(TV.Start_DateTime) as [Start], Max(TV.End_DateTime) as [End] From Travel_Visits as TV Where TV.Travel_ID = '11'
But how do I list all employees in the same column separated by commas?
The query should only return a single row and 3 columns (the two I have above, and the third with a list of employees.