08-08-2005 1:38 PM
Hi All
I want to write a query that contains subquery , any clues on that ? ( for getting max value etc )
Thanks
Sandy
08-08-2005 1:53 PM
Hi Sandy,
Extract from the Sap help :
DATA: WA TYPE SFLIGHT.
SELECT * FROM SFLIGHT
INTO WA
WHERE SEATSOCC = ( SELECT MAX( SEATSOCC ) FROM SFLIGHT ).
WRITE: / WA-CARRID, WA-CONNID, WA-FLDATE.
ENDSELECT.
Hope it helps,
Regards,
Erwan.
08-08-2005 1:55 PM
08-08-2005 2:12 PM
Hi Sandy,
here is the example.
SELECT * FROM mara
INTO imara
WHERE matnr = ( SELECT max( matnr ) FROM mara ).
write:/1 imara-matnr.
ENDSELECT.
Also you can use EXISTS with some little variations
/Manik
08-08-2005 2:18 PM
Hi Manik,
I don't really see in what way your post is different of mine...
Regards,
Erwan.
08-08-2005 3:32 PM
Hi Ewan,
It's the same, just the it was a time elapsed between your post and mine
cheers.
/Manik