Is it possible to sort a selection of 2 tables in Laravel?

Question

Laravel

Is it possible to somehow select from 2 database tables using left join, and then sort with a condition on the results of the selection in Laravel?

If you use SQL, then the selection works and looks like this:

select email from (select * from employee left join bicycle on bicycle.id = employee.bicycle_id where bicycle_id is not null) as foo where gender = 'Female';

Answer 1

rewrite the request on the builder -> get the collection -> sausage as needed.
or raw request and processing. but this is already, although possible, but not laravel-way.