Re: Syntax? error in SQL

[Michael Schutte <mschutte369@xxxxxxxxx>]

Please repost the entire select statement without breaking it up. 

Sent from my iPhone

> On Mar 31, 2016, at 7:42 AM, Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx> wrote:
>
> SELECT
> ICPRT1.IARCC9,
> ICPRT1.IAPRT#,
> Sales.ITTRND,
> Sales.ITQTY#,
> ICPRT1.IA101,
> Sales.IEQOO#,
> Sales.IEQOH#,
> Sales.IEQOR#,
> ICPRT1.IARCC6,
> Sales.ITPRT#
> FROM
> S1047N4M.ASTDTA.ICPRT1 ICPRT1
> LEFT JOIN
> In following am getting this error: what syntax error do i have?
>
> SQL0104 - Token SALES was not valid. Valid tokens: FOR USE SKIP WAIT WITH
> FETCH ORDER UNION EXCEPT OPTIMIZE.
>
> (
> SELECT
> ICPRT1.IARCC9,
> ICPRT1.IAPRT#,
> ICDET76.ITTRND,
> ICDET76.ITQTY#,
> ICPRT1.IA101,
> ICBAL1.IEQOO#,
> ICBAL1.IEQOH#,
> ICBAL1.IEQOR#,
> ICPRT1.IARCC6,
> ICDET76.ITPRT#
> FROM
> ASTDTA.ICPRT1
> LEFT JOIN ASTCCDTA.ICDET76
> ON ICPRT1.IAPRT#=ICDET76.ITPRT#
> LEFT OUTER JOIN ASTDTA.ICBAL1
> ON ICDET76.ITPRT#=ICBAL1.IEPRT#
> WHERE
> ICPRT1_1.IARCC9 = *'ACS'* --Replace this Static Value with a Command
> Object Prompt
> AND ICDET76.ITTRND *BETWEEN 20150101 AND 20150401* --Replace these two
> values with a Start and End Date Prompt
> ) Sales
> ON ICPRT1.IAPRT# = Sales.IAPRT#
> WHERE
> ICPRT1_1.IARCC9 = 'ACS' --Replace this Static Value with a Command Object
> Prompt
> -- 
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.