topic Re: subquery(urgent) in Application Development and Automation Discussions

subquery(urgent)

Former Member — Fri, 23 Mar 2007 06:55:30 GMT

i've little idea on subqueries.please tell me what's wrong with this statement and suggest the correct one.

SELECT pernr begda endda branc taete land1 zprev

zadd1 zada1 zcity1 zpin1 ztexp zprpf zprepf

zlrsn zjndes zjnctc zjncy zprdes zgrpy zlvcy

zcna1 zmal1 ztel1 zadd2 zada2 zcity2 zpin2

zcna2 zmal2 ztel2 zadd3 zada3 zcity3 zpin3 zpres

FROM pa0023

INTO TABLE ifinal

WHERE pernr IN (select pernr from pa0023

where aedtm = v_aedtm and

uname ne 'HRMYDASBAP' ).

regards,

ravi.

Re: subquery(urgent)

andreas_mann3 — Fri, 23 Mar 2007 07:59:12 GMT

I don't understand why you use a subquery here

instead of:

SELECT pernr begda endda branc taete land1 zprev

zadd1 zada1 zcity1 zpin1 ztexp zprpf zprepf

zlrsn zjndes zjnctc zjncy zprdes zgrpy zlvcy

zcna1 zmal1 ztel1 zadd2 zada2 zcity2 zpin2

zcna2 zmal2 ztel2 zadd3 zada3 zcity3 zpin3 zpres

FROM pa0023

INTO TABLE ifinal

where aedtm = v_aedtm and

uname ne 'HRMYDASBAP' .

CORRECT format is:

SELECT pernr begda endda branc taete land1 zprev

zadd1 zada1 zcity1 zpin1 ztexp zprpf zprepf zlrsn zjndes zjnctc zjncy zprdes zgrpy zlvcy

zcna1 zmal1 ztel1 zadd2 zada2 zcity2 zpin2

zcna2 zmal2 ztel2 zadd3 zada3 zcity3 zpin3 zpres

FROM pa0023

INTO TABLE ifinal

WHERE pernr = ( SELECT pernr FROM pa0022

WHERE aedtm = v_aedtm AND

uname NE 'HRMYDASBAP' ).

Message was edited by:

Andreas Mann

Re: subquery(urgent)

Former Member — Fri, 23 Mar 2007 08:04:06 GMT

SELECT pernr begda endda branc taete land1 zprev

zadd1 zada1 zcity1 zpin1 ztexp zprpf zprepf

zlrsn zjndes zjnctc zjncy zprdes zgrpy zlvcy

zcna1 zmal1 ztel1 zadd2 zada2 zcity2 zpin2

zcna2 zmal2 ztel2 zadd3 zada3 zcity3 zpin3 zpres

FROM pa0023

INTO TABLE ifinal

WHERE aedtm = v_aedtm and

uname ne 'HRMYDASBAP' .

regards

shiba dutta

Re: subquery(urgent)

Former Member — Fri, 23 Mar 2007 08:05:28 GMT

Hi,

Nothing is Wrong, But why you need to select multiple times on same table.

What about the performance.

IF you have douts still reply me.

Re: subquery(urgent)

Former Member — Fri, 23 Mar 2007 08:08:59 GMT

hi,

SELECT pernr begda endda branc taete land1 zprev

zadd1 zada1 zcity1 zpin1 ztexp zprpf zprepf

zlrsn zjndes zjnctc zjncy zprdes zgrpy zlvcy

zcna1 zmal1 ztel1 zadd2 zada2 zcity2 zpin2

zcna2 zmal2 ztel2 zadd3 zada3 zcity3 zpin3 zpres

FROM pa0023

INTO TABLE ifinal

WHERE pernr IN ( select pernr from pa0023

where aedtm = v_aedtm and

uname ne 'HRMYDASBAP' ).

regards,

ananth

Re: subquery(urgent)

Former Member — Fri, 23 Mar 2007 08:11:05 GMT

sorry i hae copied and paste your code and it is correct only only one space problem is there


SELECT pernr begda endda branc taete land1 zprev
zadd1 zada1 zcity1 zpin1 ztexp zprpf zprepf
zlrsn zjndes zjnctc zjncy zprdes zgrpy zlvcy
zcna1 zmal1 ztel1 zadd2 zada2 zcity2 zpin2
zcna2 zmal2 ztel2 zadd3 zada3 zcity3 zpin3 zpres
FROM pa0023
INTO TABLE ifinal
WHERE pernr IN ( select pernr from pa0023
where aedtm = v_aedtm and
uname ne 'HRMYDASBAP' ).

i have given a space between ( select pernr and it is not giving me any error..

regards

shiba dutta