Dan Shapir
01/27/2022, 11:23 PMSELECT * FROM A INNER JOIN B on B.aId = A.id AND B.amount < A.price
or
SELECT * FROM A INNER JOIN B on a.aId = A.id WHERE B.amount < A.price
Meaning your query’s filter parameter is part of the query itself.
I couldn’t figure anyway to do it and it’s crazy… This is a super basic SQL capability