Forum Discussion

Do5779's avatar
Do5779
Helper II
3 years ago
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...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

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.