Using MySQL (5.7+) what would be the right way to set up the OrmLite query to apply a limit to the first table in a join?
For example, say I have Customer and Order, and might do an SQL query like
SELECT * FROM
(SELECT * FROM Customer
ORDER BY Name
) AS Customer
INNER JOIN Order ON (Order.CustomerId = Customer.Id)
which gives me the first 10 customer and all their orders.
But currently, when I set up my query and call SelectMultiAsync I get a List<Tuple<Customer,Order>> with the first 10 orders and their customers.