champs Introuvable

[master_student]

Hello Guys,

I got the error bellow :

Champ introuvable - <period_id>

SELECT * FROM "GPPROD".p_edxxxll_index

left join "GPxxxxl_id

where assignment_type_id = 18

AND period_id >= 201601

and period_id <= '201710'

When i execute the query in green plume, it works perfectly :

Thank you

[Anil_Babu_Samineni]

May be Add SQL Select ....

[master_student]

the same error :

Champ introuvable - <period_id>

sql SELECT * FROM "GPPROD".xxxx

     ...

[prma7799]

Please check that period_id column is present or not in that table...

[master_student]

yes. it is here is my script:

LOAD

period_id,

     cell_id,

   cell_site_id as site_id,

    cell_name,

    cell_manufacturer,

      cell_technology,

     total_revenu as Total_revenu,

     data_revenu as Data_revenu,

     voice_revenu as Voice_revenu,

     weekend_revenu,

     weekend_data_revenu,

     weekend_voice_revenu,

     voice_off_peack_revenu as Voice_off_peack_revenu,

     voice_off_peack_data_revenu as Voice_off_peack_data_revenu,

     voice_off_peack_voice_revenu as Voice_off_peack_voice_revenu,

     data_off_peack_revenu as Data_off_peack_revenu,

     data_off_peack_data_revenu as Data_off_peack_data_revenu,

     data_off_peack_voice_revenu as Data_off_peack_voice_revenu,

     voice_on_peack_revenu as Voice_on_peack_revenu,

     voice_on_peack_data_revenu as Voice_on_peack_data_revenu,

     voice_on_peack_voice_revenu as Voice_on_peack_voice_revenu,

     data_on_peack_revenu as Data_on_peack_revenu,

     data_on_peack_data_revenu as Data_on_peack_data_revenu,

     data_on_peack_voice_revenu as Data_on_peack_voice_revenu

   ;

     sql SELECT * FROM "Gxxxndex

     left join "GPxxxndex.cell_id

     where assignment_type_id = 18

     AND period_id >= 201601

     and period_id <= 201710;

     exit script ;

[prma7799]

Try to give alias for table  and try

sql SELECT * FROM "Gxxxndex a

     left join "GPxxxndex.cell_id b

     where assignment_type_id = 18

     AND a.period_id >= 201601

     and a.period_id <= 201710;

[stabben23]

Hi, could it be that you miss ON in Your left join?

sql SELECT * FROM "Gxxxndex a

     left join "GPxxxndex.cell_id b ON

     where assignment_type_id = 18

     AND a.period_id >= 201601

     and a.period_id <= 201710;

[Anil_Babu_Samineni]

sql SELECT * FROM "Gxxxndex

    left join "GPxxxndex.cell_id

    where assignment_type_id = 18

    AND period_id >= 201601

    and period_id <= 201710;

    ...

Does Double quotes not closed anymore. May be the cause it throws error

[Peter_Cammaert]

To test, omit the Preceding LOAD or put it in comments. Then run the SQL statement on its own, and see what you get in the table viewer (Ctrl-T). DBMS that comply with the ANSI SQL standard may return field names in all upper case.