If I understand your question right, you are trying to create the join query as a view in Denodo and access it through an API. If so, I would follow the below steps:
* First, create a derived view for the JOIN query using the VQL Statement as below,
CREATE OR REPLACE VIEW AS .
* Then, publish the derived view as a [Web service](https://community.denodo.com/docs/html/browse/latest/en//vdp/administration/publication_of_web_services/publication_of_web_services#publication-of-web-services) to get the view as an API.
For information on creating Derived view using VQL, you could refer to the [Defining a Derived View](https://community.denodo.com/docs/html/browse/latest/en//vdp/vql/defining_a_derived_view/defining_a_derived_view) section of Virtual DataPort VQL Guide.
Hope this helps!