Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: normalization - two linked fields in one table

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@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 Mon Nov 11 2002 - 23:46:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US