I am starting to implement a database driven site using Weblogic. I am going to use container managed beans, so I need to use Weblogic Query language. However, so far I cannot find a way to do the following database queries.

order by
joins (including outer joins)

Any help will be appreciated.