Re: SQL question

This is very good thank you.

One ting I forgot, I have to select from t2 only those descriptions which
are a len over 39.
something like this but how do I include it in the SQL u sent?
SELECT DISTINCT SOP10200.ITEMNMBR, SOP10200.ITEMDESC FROM .sop10200 WHERE
LEN(SOP10200.ITEMDESC) > 39

On Tue, Apr 13, 2010 at 11:38 AM, Marc Couture <couturem@xxxxxxxxxxx> wrote:

Try This



SELECT
t2.itemnmbr, t1.itemdesc
FROM SOP10200 AS t1
JOIN INV00101 AS t2

ON t2.ITEMNMBR = t1.ITEMNMBR
WHERE
t2.ITEMTYPR = '2'





“If you think education is expensive, try ignorance"

(Derek Bok, pres. of Harvard Univ. 1971-1990)

Date: Tue, 13 Apr 2010 11:26:50 -0400
Subject: SQL question
From: hoteltravelfun@xxxxxxxxx
To: rpg400-l@xxxxxxxxxxxx

>

any idea why this is not compiling? it doesn't like INV00101.


SELECT
t2.[itemnmbr], t1.[itemdesc]
FROM
SOP10200 AS t1

JOIN INV00101 AS t2 ON t2.[INV00101.ITEMNMBR] = t1.[SOP10200.ITEMNMBR]
WHERE
t2.[ITEMTYPR] = '2'
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

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

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.