/*this behaves like inner join*/

select * from freight_manager

cross apply LargeOrderShippers ( freight_manager.min_value, freight_manager.max_value)

/*this behaves like cross join*/

select * from freight_manager

outer apply LargeOrderShippers ( freight_manager.min_value, freight_manager.max_value)

🙂