22 lines
380 B
SQL
22 lines
380 B
SQL
SELECT
|
|
c.JCPLCD
|
|
,a.JAPLDS
|
|
,c.JCPART
|
|
,i.DESCR
|
|
,i.STLC
|
|
,i.COLTIER
|
|
,i.BRANDING
|
|
,i.ACCS_PS
|
|
,i.SUFFIX
|
|
,i.UOMP
|
|
,c.JCUNIT
|
|
,c.JCVOLL
|
|
,c.JCPRIC
|
|
FROM
|
|
LGDAT.IPRCC c
|
|
INNER JOIN LGDAT.IPRCA a ON
|
|
a.JAPLCD = c.JCPLCD
|
|
LEFT OUTER JOIN "CMS.CUSLG".ITEMM i ON
|
|
i.ITEM = c.JCPART
|
|
WHERE
|
|
c.JCPLCD = 'NUWU' |