Join condition

Is it possible to define joint condition other than inner, right and left?
Like full outer join or outer join?