Forum Discussion
Solved
"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.le...
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.
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?
