Here is my query:
Expand|Select|Wrap|Line Numbers
- SELECT
- AssignmentLink.ItemType,
- AssignmentLink.UH,
- AssignmentLink.ItemUH,
- AssignmentLink.AssignmentUH,
- Assignment.UH,
- Assignment.Slug,
- Assignment.StartTime,
- Assignment.Location,
- Assignment.Comments,
- Assignment.Format,
- [User].UH,
- [User].UserName
- FROM
- [User],
- AssignmentLink,
- Assignment
- WHERE
- AssignmentLink.AssignmentUH = Assignment.UH
- AND
- [User].UH = AssignmentLink.ItemUH
- AND
- Assignment.Slug='CHILD SCARE'
All of the data I need in the two rows are identical except two fields. The fields are ItemType and UserName.
Can I format the query to return the ItemType and UserName fields from two matching records in a single row?