JOIN and aggregate problem
| От | Tarlika Elisabeth Schmitz | 
|---|---|
| Тема | JOIN and aggregate problem | 
| Дата | |
| Msg-id | 20090220180442.45a65170@dick.coachhouse обсуждение исходный текст | 
| Ответы | Re: JOIN and aggregate problem Re: JOIN and aggregate problem Re: JOIN and aggregate problem Re: JOIN and aggregate problem | 
| Список | pgsql-sql | 
I have 2 tables T1 and T2 T1 has the columns: D, S, C. The combination of D,S,C is unique. T2 has the columns: D, S, C, and boolean X. The combination of D,S,C is not unique. I need to produce the following result for every occurrence of T1: D,S,C, COUNT COUNT is the number of matching D,S,C combinations in T2 where X = true. There might be no matching pair in T2 or there might be match but X is false. How can I express this? -- Best Regards, Tarlika Elisabeth Schmitz
В списке pgsql-sql по дате отправления: