Hi,
This requirement can be achieved through standard VQL. I would recommend the [Defining a Derived View](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/defining_a_derived_view/defining_a_derived_view#defining-a-derived-view) documentation for the syntax. For your scenario, the derived view would look like:
```
create view T3 as
select T1.C3, T2.D1, T2.D2, T2.D3
from T1
join T2 on T1.C3=T2.D3
where T1.C1='ABC' and T1.C3 is not null
```
If you still need help and you have a valid support user account, please open a new support case at the [Denodo Support site](https://support.denodo.com/) so that the support team can assist you.
Hope this helps!