how to write delete query in advance query in outsystems -

i tried write delete query using advanced query. don't no how write query in advance query still tried getting error.please me how write query example.

i want delete data "envelopeheader" entity.

if you're using

delete table table.column in (...) 

that means inner query must return list of values same type table.column.

in case inner query:

1. is selecting bunch o columns, , should selecting one
2. when selecting multiple columns need commas separate columns want select col1, col2
3. you need specify statement inner query

it should like

delete {table} {table}.[column] in (select {table}.[column] {table} <condition>) 

also don't forget if want use parameters, can refer them using @param_name