APEX

I've very quickly built a large query with the query builder, and it works fine, but only produces 9 out of 2200 records - so I need to change it to an outer join.

My problem is that I can't seem to find a way to specify an outer join. I've tried editing the query that query builder formed, but it won't let me.

I know I can capture the query, edit it and run it in sql developer, and that works fine, but I want to use query builder as it is the fastest way I know of to quickly add and remove items - my users are unsure of exactly what to include.

I know it is kind of a trivial question, but i've searched the forum, the manual, the web and no luck

Thanks for any help you can give

Glenn