Queries with joins

[Josejulio Martínez]

Hello, 

I would like to know if is possible to do the following in ormlite using the Where (what i don't want is using the raw query if possible).

SELECT invoice.* 

FROM invoice

JOIN invoice_client ON invoice.invoice_id = invoice_client.invoice_id

WHERE invoice_client.rfc= "XXX101010HY3";

What i want to do is perform certain filters on other tables(using join) but only retrieving the base object in this case the Invoice object.

[jc]

You should be able to use the Where.in(subquery) to get the result you
want although it doesn't technically do a join.

To do this create two QueryBuilder objects, one for the "invoice" and
another for "invoice_client". For the invoice_client, define your
where however you want and then use it as the argument of the where.in
in your "invoice" QueryBuilder.

[Josejulio Martínez]

Thank you, that works for me very well.