No subject

[Marek Reichenbach]

I'm trying to do in LiveCode with MySQL:
how to use data from other table in the same query for filtering:

SELECT A, B ,C, (SELECT D FROM TABLE2 WHERE C[from table2] < B[from
table1]) FROM TABLE1; <-- the stucture of query

help please :/