topic Re: INNER join with dynamic table name ? in Application Development and Automation Discussions

INNER join with dynamic table name ?

Former Member — Fri, 14 Sep 2007 07:27:55 GMT

Hi,

I have a problem with this statement.

DATA: g_dso_bic_dofr TYPE tabname.

SELECT t1~/bic/ziparomr
       t2~/bic/zifremom
 INTO (wa_rater_paromr-/bic/ziparomr,
       wa_rater_paromr-/bic/zifremom)

*   FROM /bic/azd0bfr5100 AS t1     "equivalent to the dynamic statement below

" this is the  problem
    FROM (g_dso_bic_dofr )AS t1
    INNER JOIN /bic/pzifremom AS t2 
      ON t1~/bic/ziparomr = t2~/bic/ziparomr 
" --- to here 

    WHERE t1~/bic/zikom     =  v_kommune

The compile check doesnt work when i use the variable table name.

I get

"Wrong expression "INNER" in FROM clause. WHERE condition."

Can anyone help me.

Br Rasmus.

Re: INNER join with dynamic table name ?

JozsefSzikszai — Fri, 14 Sep 2007 07:41:50 GMT

hi Rasmus,

I tried and it looks like that it does not work...

Re: INNER join with dynamic table name ?

Former Member — Fri, 14 Sep 2007 22:53:06 GMT

Check my weblog...It might help you -;)

Greetings,

Blag.

Re: INNER join with dynamic table name ?

alejandro_bindi — Fri, 14 Sep 2007 23:13:13 GMT

" this is the  problem
*    FROM (g_dso_bic_dofr )AS t1   "<<--- check spaces in here
    FROM (g_dso_bic_dofr) AS t1    "<<--- and here
    INNER JOIN /bic/pzifremom AS t2 
      ON t1~/bic/ziparomr = t2~/bic/ziparomr 
" --- to here

I think there's the problem, the space behind the parenthesis.

Regards

Re: INNER join with dynamic table name ?

Former Member — Wed, 21 Nov 2007 15:45:24 GMT

This is for no reason an illegal statement.

Solved with an internal table and FOR ALL ENTRIES