how to use join

[odion-cloud]

i want to select my by this is my code
'where_raw' => 'transaction.id = (SELECT * FROM transactions INNER JOIN users ON users.id = transactions.payable_id)',

but did not return any data
pls how can i achieve this or correct code

[PovilasKorop]

@odion-cloud we don't have anything for JOIN syntax, it's not supported by our package.