Re: SQL Question Part 2

["Rolf Mittag" <rm@xxxxxxxxxxxx>]

>     61        C+   From ( LDATAQ1C/SRVMLD JOIN LDATAQ1C/SRVALT1 On
>
>     62        C+    M1LOAN = A1LOAN )  Join LDATAQ1C/SRVDSRLZZ On
>
>     63        C+    A1LOAN = CATL#

why not

c+    from LDATAQ1C/SRVMLD
c+        JOIN LDATAQ1C/SRVALT1 On M1LOAN = A1LOAN
c+        Join LDATAQ1C/SRVDSRLZZ On A1LOAN = CATL#

for what do you need brackets "(" ")" ?

hth Rolf

---------------------------
Dipl.Inf.(FH) Rolf P Mittag
IBM Partner in Development
Leipziger Str. 50
D-69214 Eppelheim
Fon: +49 (6221) 76 78 60
Fax: +49 (6221) 76 80 26
eMl: rm@r-m-e-d-v.de

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorised copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
----- Original Message -----
From: "Cyndi Bradberry" <CyndiB@IHFA.ORG>
To: "'Midrange-L@midrange. com' (E-mail)" <Midrange-L@midrange.com>
Sent: Wednesday, June 20, 2001 6:30 PM
Subject: SQL Question Part 2


> We worked out the problem with the ISO dates, and have moved on to another
> program.  I am trying to Join together 3 files with a common field (LOAN
> NUMBER).  This Select statement works in ISQL, but I get this error when I
> try to put it into a program:
>
>  MSG ID  SEV  RECORD  TEXT
>
>  SQL0199  30      61  Position 34 Keyword JOIN not expected. Valid
tokens: )
> ,.
>
>     57        C/Exec SQL
>
>     58        C+ Declare MasterTable Cursor
>
>     59        C+   For Select M1LOAN, SMA450, SMA240
>
>     60        C+              A1FNAM, A1LNAM, A1HARA, A1HPFX, A1HNBR,
>
>     61        C+   From ( LDATAQ1C/SRVMLD JOIN LDATAQ1C/SRVALT1 On
>
>     62        C+    M1LOAN = A1LOAN )  Join LDATAQ1C/SRVDSRLZZ On
>
>     63        C+    A1LOAN = CATL#
>
>     64        C+   Where SMA240 > 0 and
>
>     65        C+         (SMA450 >= 17 and SMA450 <= 31) and
>
>     66        C+         A1SEQ = 01
>
>     67        C+   Order By A1LNAM
>
>     68        C+   For Fetch Only
>
> Can anyone help me to see where I have gone wrong ?  I really can't see
the
> forest for the trees.  We are at V4R4, current on CUM and Group PTF's
(Just
> applied a bunch of SQL PTF's this morning ;-).
>
> Cyndi B.
> Boise, ID
>
> PS:  Is there anyone else from Boise/Nampa/Caldwell on the list ?  Direct
> mail please !
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---