RE: SQL question

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.