dynamic inner joins

[Former Member]

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

[Former Member]

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

[anversha_s]

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

[Former Member]

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.

[Former Member]

Hi

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

[Former Member]

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