How would i get all vendor bills lines for a vendor where the lines have a specific account id?

Something like

SELECT transactionline.*
FROM transaction
JOIN transactionline ON transaction.id = transactionline.transaction
WHERE transaction.entity = <vendor_id>
AND transaction.type = ‘VendBill ’
AND transactionline.expenseaccount = <account_id>

?

Thanks Jen! ill give this a try

I mean I don’t know if that’s correct, it’s 7am and I haven’t had coffee yet