Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
Hi, @Do5779 ;
I try it and you could create a sql ;
Select * from Databasemouse
where (Databasemouse.legs + Databasemouse.Arm)>2
The 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.
Hi, @Do5779 ;
I try it and you could create a sql ;
Select * from Databasemouse
where (Databasemouse.legs + Databasemouse.Arm)>2
The 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?