Is there a way to JOIN in caravel?

[Aram Lauxtermann]

Basically I have two tables in the same database and I want to join them.

Aka created a virtual column in one table that adds a friendly name:

SELECT database_1.*, database_2.device_type

FROM database_1  

INNER JOIN database_2 ON database_2.user_agent = database_1.agent

Is it possible to do this in caravel?

Tnx

[Maxime Beauchemin]

You can use a view that has a join in it as a data source.

Max

[Maxime Beauchemin]

http://airbnb.io/caravel/faq.html#can-i-query-join-multiple-tables-at-one-time

[Aram Lauxtermann]

PS.

Or is there a way to at a table do a JOIN on it and save it?

Because I can JOIN in SQL page. The only problem is that I cannot create a view, because I get a alert that states that this feature is not implemented yet.

Tnx

[Maxime Beauchemin]

Yes, it's not implemented yet. In the meantime you just have to run a `CREATE VIEW foo {my_sql_statement_with_join_in_it};` against your database and use `foo` as a source.

[Aram Lauxtermann]

Tnx