Creating a single row from two

[!NoItAll]

I have an SQL Query that works very well with one exception... (I guess you could say it doesn't work THAT well). I have it retrieving the information I need, but the data comes back in TWO rows and I need it in one.
Here is my query:

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'
 

The "Child Scare" slug is unimportant, that was for debugging purposes. There is only ONE record in the system (comprised of two rows returned) with 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?

[Seth Schrock]

Somewhere you have a many-to-one relationship and one of the tables has two records matching the criteria. Without seeing your data and knowing exactly what you want done, I can't be very specific, but what I normally do is to use subqueries to get the values I need as different fields instead of different records. For example, if an assignmentlink record is related to two different assignments, then you would create two subqueries. The first subquery would get the first record and the second subquery would get the second record. You can then display the data all in one record, even though it is coming from two different records.