Re: Aliias names in select criteria

On Tue, 4 Jun 2002, Bob Powell wrote:

>
> To whom it may concern:
>
> The following selection criteria causes my box to start a process that gives no result.
>
> SELECT P.Last_Name, P.First_Name, S.Status, S.Entry_Year,
> S.Graduation_Year, S.Former_School, S.Day_or_Board, S.Admissions_Id,
> P.Participant_Id, P.Birthday, P.Modification_Date FROM Participants P,
> Students S WHERE Participant.Participant_Id = Students.Participant_Id

AFAIK the above is technically illegal. Postgres assumes you meant to
have Participant and Students in the from list (in addition to P and S)
and thus you get a 4 way join with only some of the tables being
constrained.