Re: Reports 6i, (+) in Link?

From: MarkyG <markg_at_mymail.tm>
Date: 2 Jul 2001 01:22:33 -0700
Message-ID: <ab87195e.0107020022.f79a6cc_at_posting.google.com>


Yep, create your query as normal and once finished, edit the SQL and add it in manually.
Most reporting tool wizards don't normally 'support' outer joins, its normally a manual thing.

M

richard.anderson_at_nelincs.gov.uk (Rick4096) wrote in message news:<fbc06235.0106300218.c6e2902_at_posting.google.com>...
> Hi, I'm using Reports 6i, and have 3 query groups in the Data Model.
>
> Using Data Links, I have joined the three queries.
>
> Is it possible to have this join include ALL records from one query
> and only related records from the other. In other words like this:
>
> WHERE TABLE1.REFERENCE (+) = TABLE2.REFERENCE
>
>
> (MY EMAIL ADDRESS IS rick4096_at_my-deja.com )
>
> Many thanks, Rick Anderson.
Received on Mon Jul 02 2001 - 10:22:33 CEST

Original text of this message