Re: Trouble with an outer join -- MIDRANGE-L

Emily,

As you are using a QMQRY, you can create and use a QRYFORM as well.

In QMQRY edit mode, run the query for output to screen, and return to the
edit query screen.
Press F13 and you can create a QMFORM. In the first option you can put a
BREAK1 on SEQUENCE and (optional) a SUM on SEL2.
Press Enter and then F5. as the result table is still in memory it will
display it in the new FORMat.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR ***********

On 6-8-2008 at 13:53 Emily Smith wrote:

Carel - Thanks for the response, I tried it out and got the same results.

Elvis - I tried your suggestion and I'm now getting three rows. The
problem now is that
The data from BRNDETLF is in each row...

Record 1: Sequence = 01, Descript = 'Bundled Twenties', Sel1 = 600.00,
Sequence2 = 01, Descript2 = 'Loose Twenties'
Sel2 = 100.00
Record 2: Sequence = 01, Descript = 'Bundled Twenties', Sel1 = 600.00,
Sequence2 = 01, Descript2 = 'Loose Twenties'
Sel2 = 60.00
Record 3: Sequence = 01, Descript = 'Bundled Twenties', Sel1 = 600.00,
Sequence2 = 01, Descript2 = 'Loose Twenties'
Sel2 = 80.00

Is it possible to accomplish the following results?

Record 1: Sequence = 01, Descript = 'Bundled Twenties', Sel1 = 600.00,
Sequence2 = 01, Descript2 = 'Loose Twenties'
Sel2 = 100.00
Record 2: Sequence = null, Descript = null, Sel1 = null, Sequence2 = 01,
Descript2 = 'Loose Twenties'
Sel2 = 60.00
Record 3: Sequence = null, Descript = null, Sel1 =null, Sequence2 = 01,
Descript2 = 'LooseTwenties'
Sel2 = 80.00

Thanks for helping me with this.

Emily Smith
Programmer/Analyst
Bank Data Services
(618)659-4550

CONFIDENTIALITY NOTICE: This email message is private,
confidential property of the sender, and the materials
may be privileged communications intended solely for
the receipt, use, benefit, and information of the intended
recipient indicated above. If you are not the intended
recipient, you are hereby notified that any review,
disclosure,distribution, copying or taking of any
other action in reference to the contents of this message
is strictly prohibited, and may result in legal liability
on your part. If you have received this message in error,
please notify the sender immediately and delete this
message from your system. We believe that this email
and any attachments are free of any virus or other defect
that might affect any computer system that it is received
and opened in, however, it is the responsibility of the
recipient to ensure that it is virus free and the sender
accepts no responsibility for any loss or damage.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Internal Virus Database is out of date.
Checked by AVG.
Version: 8.0.101 / Virus Database: 270.5.10/1584 - Release Date: 31-7-2008
12:00