Gaurav Jindal wrote
> a has relation with b and b has relation with c
Given this statement what specifically are you having difficulty with. You
are allowed to perform multiple joins, whether explicit or via FROM/WHERE,
in the same query.
SELECT ...
FROM a,b,c
WHERE a=b and b=c
OR
SELECT ...
F
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
