Forum Discussion
"where (select...) " SQL in M / Queryeditor
Hello,
I have following issue:
Is in M a possibility to wirte a SQL statement with a "under-Select ", e.g.
Select Databasemouse.Animal from Databasemouse
where (Select (Databasemouse.legs + Databasemouse.Arm)>2 from Databasemouse)
Databasemouse:
| Animal | Enemy | Legs | Arm |
| Mouse | Snake | 2 | 2 |
| Dog | Lion | 0 | 1 |
Hi, Do5779 ;
I try it and you could create a sql ;
Select * from Databasemouse where (Databasemouse.legs + Databasemouse.Arm)>2The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Do5779 Do you want to convert a SQL code to M or just want to use SQL statement to load data into Power Query?
thank you for your respone. I only want to execute a SQL statement (advanced editor) with a "where select"-statement and I don't know why it isn't working.
Do5779 If you are thinking about querying the table of an M code using SQL then that can't be done, if you are trying to query the Database using SQL then what is the error that you are getting?
Hi, Do5779 ;
I try it and you could create a sql ;
Select * from Databasemouse where (Databasemouse.legs + Databasemouse.Arm)>2The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
