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 :). 

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Are you sure you posted this question in the right forum?

This looks like SQL and not PowerQuery to me ...