There is an array `@array = select username from usertable`
and the **parameter** is passed to the other query

```
SELECT
*
FROM transactiontable TT
WHERE TT.name in (SELECT value FROM string_split(@array, ','))

```

What is the benifit of doing this?

Can't I just do `SELECT * from transcationtbale TT WHERE TT.name in @array`?

Also, what is `SELECT value FROM expression`?

Thanks