Complex query
От | Leonardo M. Ramé |
---|---|
Тема | Complex query |
Дата | |
Msg-id | 20140331183815.GA10833@leonardo-laptop обсуждение исходный текст |
Ответы |
Re: Complex query
Re: Complex query Re: Complex query |
Список | pgsql-general |
Hi, I'm looking for help with this query. Table Tasks: IdTask StatusCode StatusName ---------------------------------- 1 R Registered 1 S Started 1 D Dictated 1 F Finished 1 T Transcribed ---------------------------------- 2 R Registered 2 S Started 2 T Transcribed 2 F Finished As you can see, I have a table containing tasks and statuses. What I would like to get is the list of tasks, including all of its steps, for only those tasks where the StatusCode sequence was S followed by T. In this example, the query should only return task Nº 2: 2 R Registered 2 S Started 2 T Transcribed 2 F Finished Can anybody help me with this?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877
В списке pgsql-general по дате отправления: