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 по дате отправления: