I have created some views which give me some values.
So some thing like the following
select from a table of all ids gives me some thing like
id1
id2
id3
id4
view1 gives me
id1 2
id1 1
id1 3
id2 1
view2 gives me
id3 London
id3 Paris
id1 London
What I need is some thing like
id1 6 1
id2 1 0
id3 0 2
id4 0 0
As you can see that I need aggregation of numbers from first view and aggregation of number os cities from second view. What would be a way to do this?
id1 6 0
and notid1 6 1
, orid1 1 6
?