"where (select...) " SQL in M / Queryeditor

[Do5779]

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

[v-yalanwu-msft · Accepted 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.

[AntrikshSharma]

@Do5779 Do you want to convert a SQL code to M or just want to use SQL statement to load data into Power Query?

[Do5779]

@AntrikshSharma ,

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.

[AntrikshSharma]

@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?