Re: normalization - two linked fields in one table

> SELECT t.TaskID, a.name as Assignee, p.name as Poster
> FROM (Task as t INNER JOIN User as a ON t.assigned_to=a.UserID)
> INNER JOIN User as p ON t.poster_id=a.UserID

This code works perfectly. I tried looking in my MS Access book, but the example they gave of nested INNER JOINS was rather complicated with no "real life" example.

This makes sense though.

Thank you!!
Trooper

11-Nov-2002