How can I get the account number from these tables?

Hi,

issue:

I have an sql query that works with a custom "specialfield1" in transactionline table:

{   "q": "SELECT * FROM transaction t LEFT JOIN transactionline tl ON t.id = tl.transaction where tl.specialfield1 IS NOT NULL and t.trandate >= '11/1/2021'"

}

However I need to also get the account number for these results.

I am not sure what to match with the account table using the transaction - transactionline table???

Can you let me know how to also retrieve the account number for these using additional query matches and tables?

THANKS