Need query

Поиск
Список
Период
Сортировка
От Gaurav Jindal
Тема Need query
Дата
Msg-id CAFWM-9s9c5HZBEovH+FRHBfdcpBa8c1w-L2T-wjzhPi0-DC+ag@mail.gmail.com
обсуждение исходный текст
Ответы Re: Need query
Список pgsql-general
Дерево обсуждения
Can anybody help me with query-

I have 3 tables- a,b,c

a has relation with b and b has relation with c
a does not have a relation with c 


I need to find top performing item in table 'a'. It is based on count. If more count, it is top performing. We can count only based on actions in table 'c'. I can put 'where' clause in table 'c' and find those values. I can't join table 'a' and 'c' as they don't have any relation. 


select b.top 
FROM b,c
WHERE c.action IN ('blah', 'blah', 'any values')  and b.id = c.id;

'top' in the query is a common column  in table 'a' named 'a_top'. We need to count column 'track' in table 'a' based on this information.

В списке pgsql-general по дате отправления: