I tried to your solution with below script. it executes successfully but no message at recipient end. Can you please me

____________________________________________________________________________

EXEC msdb.dbo.sp_send_dbmail

@recipients= 'abc@hotmail.com'

...

No You can't use it as [flag='y'].some_data, because you not give the table alias and fetching the column with reference to table alias, it can be work as select...