|
|
| Author |
Message |
srini_gunja
Currently Banned
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 |
|
| Back to top |
|
 |
References
|
 Posted: Fri Apr 25, 2008 10:27 am Post subject: Re: Query from two DB2 tables |
|
|
|
|
enrico-sorichetti
Global Moderator
Joined: 14 Mar 2007
Posts: 2415
Location: italy
|
|
|
|
what king of help do You need ...
did You try Your query under spufi ? |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 881
Location: Virginia, USA
|
|
|
|
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 |
|
| Back to top |
|
|
dick scherrer
Global Moderator
Joined: 23 Nov 2006
Posts: 6883
Location: 221 B Baker St
|
|
|
|
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 |
|
| Back to top |
|
|
|
|
