Jdbc Adapter - Left Join

Is it possible to implement a LEFT JOIN within a SELECT SQL adapter or the only way is using the custom adapter?

Thanks everybody
Cheers!
Fabrizio