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