work of Views in GIS

I have for example three classes: A,B,C. Attribute C.attrc refer to some card of B, and attribute B.attrb refer to a card from A.
I want to see all cards from C that linked through some cards of B with the one card ‘a’ from A (let call it MyQuery).
Filters can’t do that to me (am i right?).

But View based on SQL can do that.
But even View on simple filter works in table mode:
table,
but in GIS it throw some indistinct error:
map

QUESTION: Is it possible to run MyQuery in GIS?