Forum Discussion

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Query that doesn't work

It's probably just me... but my query isn't working. It tell me that 'G_EF.mximpl' is invalid.   Select G.line_item_id , G.price , G_EF.mximpl FROM mn_price_master_li G inner join ( SELECT ...
Need Help
  • DouweMeer's avatar
    DouweMeer
    5 years ago

    So, I've found the problem.  

    ["mximpl"] is not matching with [G_EF.mximpl], it is supposed to be [G_EF."mximpl"] to make it work. 

    Silly flaw :). 

     

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
5 years ago

Small:

Small query with only G_EF

Result of small:

Result of small query with only G_EF

Attempt on longer one

Long:

Larger query merging G_EF with G.

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi DouweMeer ,

 

Please run the SQL command in your database firstly to check if it will return the correct result. And please check if there is any special character in the G_EF.maxeff column.

 

 

  • DouweMeer's avatar
    DouweMeer
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    So, I've found the problem.  

    ["mximpl"] is not matching with [G_EF.mximpl], it is supposed to be [G_EF."mximpl"] to make it work. 

    Silly flaw :).