It can do complicated SQL SELECT statements- with some restrictions.
For one, it doesn't display tables. It'll automatically trunc it to the first entry. (so the first sql will only give the first engineID, while the second gives the node.caption)
Unless the table is empty. Then it displays the query, which is what you are seeing now.
I'd try to keep those sql statements simple because debugging/testing on the alert writer is cumbersome, but if you need to check, I'd use report writer to test the output as it should display the same things.
Thanks, zzz. That makes since then cause the query should be blank now. I did not realize it would return the query, i expected it to show blank. Thanks for the help.