Re: normalization - two linked fields in one table
From: Trooper <andrew_zx5_at_NOSPAMyahoo.com>
Date: Tue, 12 Nov 2002 05:46:08 GMT
Message-ID: <AA0A9.803527$Ag2.27276465_at_news2.calgary.shaw.ca>
Received on Tue Nov 12 2002 - 06:46:08 CET
Date: Tue, 12 Nov 2002 05:46:08 GMT
Message-ID: <AA0A9.803527$Ag2.27276465_at_news2.calgary.shaw.ca>
> 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
Received on Tue Nov 12 2002 - 06:46:08 CET