topic Re: REGARDING SELECT STATEMENT in Application Development and Automation Discussions

REGARDING SELECT STATEMENT

Former Member — Thu, 04 Jan 2007 12:00:19 GMT

HI champions,

i m facing problem in this select statement........its giving error...plz help me.

here im giving the complete scenario....

REPORT ZW.

tablEs:sbook.

select carrid connid count( * ) SUM( LUGGWEIGHT ) INTO (CARRID,CONNID,COUNT,SUM_WEIGHT) FROM SBOOK WHERE CARRID = 'LH' GROUP BY CARRID CONNID HAVING SUM( LUGGWEIGHT ) > 25.

WRITE:/ CARRID,CONNID,COUNT,SUM_WEIGHT.

ENDSELECT.

Re: REGARDING SELECT STATEMENT

Former Member — Thu, 04 Jan 2007 12:21:45 GMT

Hello Ravi,

Can you also please give the text of the error ?

Avisesh.

Re: REGARDING SELECT STATEMENT

srinivas_akiri — Thu, 04 Jan 2007 12:41:20 GMT

Hi ravi,

use need to use the table name as qualifier, here is the corrected code

tablEs: sbook.

data: count type i,

sum_weight type i.

select carrid connid count( * ) SUM( LUGGWEIGHT )

FROM SBOOK

INTO (SBOOK-CARRID, SBOOK-CONNID, COUNT, SUM_WEIGHT)

WHERE CARRID = 'LH'

GROUP BY CARRID CONNID

HAVING SUM( LUGGWEIGHT ) > 25.

WRITE:/ SBOOK-CARRID, SBOOK-CONNID, COUNT, SUM_WEIGHT.

ENDSELECT.

Thanks

Srini