You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by "Jonnalagadda, Sumithra" <su...@amgen.com> on 2006/02/03 16:10:23 UTC

For sql experts 

SELECT DEPTNUM.REF_VALUE, CAMNUM.REF_VALUE, 
(SELECT PN1.NOTE_TEXT FROM PARTY_NOTE PN 1WHERE PN.1PARTY_ID =
DEPTNUM.PARTY_ID and max(pn1.last_update_dt)) NOTE
FROM PARTY_REFERENCE DEPTNUM,
PARTY_REFERENCE CAMNUM,
PARTY_ASSOC REL
WHERE DEPTNUM.PARTY_ID = REL.TO_PARTY_ID
AND REL.FROM_PARTY_ID = CAMNUM.PARTY_ID
AND DEPTNUM.PARTY_REF_TYPE_CD = 'TYPE1
AND CAMNUM.PARTY_REF_TYPE_CD = 'TYPE2'

The problem is the the sub query 
SELECT PN1.NOTE_TEXT FROM PARTY_NOTE PN 1WHERE PN.1PARTY_ID =
DEPTNUM.PARTY_ID and max(pn1.last_update_dt 

is not working. 

My requirement is in the sub query I want to select those notes with
last_update_dt is maximun for each party.

Any help is appriciated. 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org

Re: For sql experts

Posted by ALEX HYDE <al...@btinternet.com>.
  
FROM PARTY_NOTE PN 1WHERE PN.1PARTY_ID

might have to be... 

FROM PARTY_NOTE PN1 WHERE PN1.PARTY_ID



What happens if you get more than one last_update_dt 
equal to the maximum?


Gluck

  
  

"Jonnalagadda, Sumithra" <su...@amgen.com> wrote:  
SELECT DEPTNUM.REF_VALUE, CAMNUM.REF_VALUE, 
(SELECT PN1.NOTE_TEXT FROM PARTY_NOTE PN 1WHERE PN.1PARTY_ID =
DEPTNUM.PARTY_ID and max(pn1.last_update_dt)) NOTE
FROM PARTY_REFERENCE DEPTNUM,
PARTY_REFERENCE CAMNUM,
PARTY_ASSOC REL
WHERE DEPTNUM.PARTY_ID = REL.TO_PARTY_ID
AND REL.FROM_PARTY_ID = CAMNUM.PARTY_ID
AND DEPTNUM.PARTY_REF_TYPE_CD = 'TYPE1
AND CAMNUM.PARTY_REF_TYPE_CD = 'TYPE2'

The problem is the the sub query 
SELECT PN1.NOTE_TEXT FROM PARTY_NOTE PN 1WHERE PN.1PARTY_ID =
DEPTNUM.PARTY_ID and max(pn1.last_update_dt 

is not working. 

My requirement is in the sub query I want to select those notes with
last_update_dt is maximun for each party.

Any help is appriciated. 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org




		
---------------------------------
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre.