Query from two DB2 tables

srini_gunja · New User Joined: 24 Aug 2005 Posts: 7

Hi All,

Can anybody help me in querying two DB2 tables with join.

here is the query.

SELECT
SO31.CTID
,SO31.NFNCD1
,SO31.CAEFA
,SO31.DFNDT
,SO31.GRID
,SO31.AACVAO
,SO34.DSLOI2
,SO34.IDARC
FROM
CORP.TBSO31
,CORP.TBSO34
WHERE
SO31.CTID = '67739425'
AND SO31.NFNCD1 = SO34.NFNCD1
AND SO31.CAEFA = SO34.CAEFA
AND SO31.GRID = SO34.GRID

thanks, Srini

enrico-sorichetti · Posted: Fri Apr 25, 2008 10:31 am

what king of help do You need ...
did You try Your query under spufi ?

Craq Giegerich · Posted: Fri Apr 25, 2008 5:52 pm

Some explanation of your problem would help?

SELECT
SO31.CTID
,SO31.NFNCD1
,SO31.CAEFA
,SO31.DFNDT
,SO31.GRID
,SO31.AACVAO
,SO34.DSLOI2
,SO34.IDARC
FROM
CORP.TBSO31 SO31
,CORP.TBSO34 SO34
WHERE
SO31.CTID = '67739425'
AND SO31.NFNCD1 = SO34.NFNCD1
AND SO31.CAEFA = SO34.CAEFA
AND SO31.GRID = SO34.GRID

dick scherrer · Posted: Fri Apr 25, 2008 9:00 pm

Kinda tough for them to reply when they have been banned. . .

Seemed like a rather severe penalty for not asking the question very well.

d