Aliias names in select criteria
От | Bob Powell |
---|---|
Тема | Aliias names in select criteria |
Дата | |
Msg-id | scfcb766.069@grpwise.hotchkiss.org обсуждение исходный текст |
Ответы |
Re: Aliias names in select criteria
Re: Aliias names in select criteria Re: Aliias names in select criteria |
Список | pgsql-general |
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 It also throws the linux box into a process that has to be killed even though I've exited the client. I found the problem to be the non-use of the alias after the WHERE clause If I rerun this as below without the full tablename and using the alias it works. Is this a normal occurrence. Other systems I have used work either way. 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 P.Participant_Id = S.Participant_Id Bob Powell
В списке pgsql-general по дате отправления: