topic Re: dynamic inner joins in Application Development and Automation Discussions

dynamic inner joins

Former Member — Tue, 12 Jun 2007 08:30:57 GMT

hi ,

would any body suggest anything over the following code--- where there is wrong .

DATA itab LIKE SORTED TABLE OF wa

WITH UNIQUE KEY fldate carrname connid.

data : var(80) value 'scarr AS c INNER JOIN spfli AS p ON p_{carrid = c}carrid',

var1(80) value 'AND p_{cityfrom = p_cityfr AND p}cityto = p_cityto'.

SELECT c_{carrname p}connid

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( (var)

(var1) ).

thanks

Jags

Re: dynamic inner joins

anversha_s — Tue, 12 Jun 2007 08:35:30 GMT

hi,

change ur code like this.


DATA itab LIKE SORTED TABLE OF wa 
WITH UNIQUE KEY fldate carrname connid. 

SELECT c~carrname p~connid INTO CORRESPONDING FIELDS OF TABLE itab 
from scarr AS c inner join spfli AS p
on
p~carrid = c~carrid
AND p~cityfrom = p_cityfr 
AND p~cityto = p_cityto.

Regards

Anversha

Re: dynamic inner joins

Former Member — Tue, 12 Jun 2007 08:37:14 GMT

hi jagadeesh,

instead of your code u can write like this,

SELECT scarr_{carrname spfli}connid

INTO CORRESPONDING FIELDS OF TABLE itab

FROM scarr AS c innner join spfli AS p on p_{carrid = c}carrid AND p_{cityfrom = p_cityfr AND p}cityto = p_cityto.

then u can give even where condition if u want.

reward points if helpful.

regards,

seshu.

Re: dynamic inner joins

Former Member — Tue, 12 Jun 2007 08:37:28 GMT

The select statement won't take dynamic variables like what you defined var and VAR1.

it won't work. you have to write the same what is there in the variable completely.

SELECT c_{carrname p}connid

INTO CORRESPONDING FIELDS OF TABLE itab

FROM scarr AS c INNER JOIN spfli AS p ON p_{carrid = c}carrid

AND p_{cityfrom = p_cityfr AND p}cityto = p_cityto.

Reward points for useful Answers

Regards

Anji

Re: dynamic inner joins

Former Member — Tue, 12 Jun 2007 08:39:02 GMT

hi Jagdeesh,

there is a small confusion in using 'ON' and 'WHERE'.

Plz go ahead and changes accordingly.

DATA itab LIKE SORTED TABLE OF wa

WITH UNIQUE KEY fldate carrname connid.

data : var(80) value 'scarr AS c INNER JOIN spfli AS p ON p_{carrid = c}carrid',

var1(80) value '<b>WHERE</b> p_{cityfrom = p_cityfr AND p}cityto = p_cityto'.

SELECT c_{carrname p}connid

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( (var)

(var1) ).

<b>Plz award points if this solved ur problem.</b>

Regards,

Kiran

thanks

Jags