Beniamin Joke (7/14/2013)
i want the result for which :table GLMSO which has the
gmso colum 0003 and has both of bot
of KCTR's in GLCTA table
06 Eme3Prodcat2x
07 Eme4Prod
SELECT DISTINCT
GLPSI.IDN AS GLMSO_GLPSI_IDN,
GLMSO.IDN AS GLMSO_IDN,
-- GLMSO.KMSO,
GLMSO.FAB,
GLMSO.DFINV,
GLMSO.DFINA,
GLCTA.KCTR,
GLCTA.DCAT
FROM GLMSO
INNER JOIN GLARA ON GLARA.IDN = GLMSO.IDN
AND GLARA.KARA = GLMSO.KARA
INNER JOIN GLPSI ON GLPSI.IDN = GLARA.IDN
AND GLPSI.KPSI = GLARA.KPSI
INNER JOIN GLCMS ON GLCMS.IDN = GLMSO.IDN
AND GLCMS.KMSO = GLMSO.KMSO
INNER JOIN GLCVA ON GLCMS.IDN = GLCVA.IDN
AND GLCMS.KCVA = GLCVA.KCVA
INNER JOIN GLCTR ON GLCVA.IDN = GLCTR.IDN
AND GLCVA.KCTR = GLCTR.KCTR
INNER JOIN GLCTA ON GLMSO.IDN = GLCTA.IDN
AND GLMSO.KARA = GLCTA.KARA
WHERE ( GLPSI.IDN = '0099' )
AND ( GLMSO.FAB = 'A' )
SELECT DISTINCT
GLPSI.IDN AS GLMSO_GLPSI_IDN,
GLMSO.IDN AS GLMSO_IDN,
GLMSO.KMSO,
GLMSO.FAB,
GLMSO.DFINV,
GLMSO.DFINA,
GLCTA.KCTR,
GLCTA.DCAT
FROM GLMSO
INNER JOIN GLARA ON GLARA.IDN = GLMSO.IDN
AND GLARA.KARA = GLMSO.KARA
INNER JOIN GLPSI ON GLPSI.IDN = GLARA.IDN
AND GLPSI.KPSI = GLARA.KPSI
INNER JOIN GLCMS ON GLCMS.IDN = GLMSO.IDN
AND GLCMS.KMSO = GLMSO.KMSO
INNER JOIN GLCVA ON GLCMS.IDN = GLCVA.IDN
AND GLCMS.KCVA = GLCVA.KCVA
INNER JOIN GLCTR ON GLCVA.IDN = GLCTR.IDN
AND GLCVA.KCTR = GLCTR.KCTR
INNER JOIN GLCTA ON GLMSO.IDN = GLCTA.IDN
AND GLMSO.KARA = GLCTA.KARA
WHERE ( GLPSI.IDN = '0099' )
AND ( GLMSO.FAB = 'A' )
AND ( GLMSO.KMSO = '0003' )
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day