select join as

[Thiebo]

I have one table "data"

   Column       | 
---------------------+
 id                    |
 account_id    |
 categorie_id  |
 amount          |


And a table "categories"

   Column       |
---------------------+
 id                    |
 name             |

I want to "translate" this SQL query into Sequel:

 SELECT data.id, data.amount, data.name, data.data, categories.name as 
categorie FROM data RIGHT OUTER JOIN categories ON(categories.id = 
data.categorie_id);

I can't find in the documentation (
https://sequel.jeremyevans.net/rdoc/files/doc/querying_rdoc.html) how to 
select specific fields in a join query and how to select "as". 

Thanks

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/20dfef93-e4c0-43e7-b0cd-ebecaea4107en%40googlegroups.com.