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>


> 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

Original text of this message