No subject

[Pete]

SELECT A,B,C,TABLE2.D FROM TABLE1 LEFT JOIN TABLE2 ON TABLE2.C < TABLE1.B
On Mar 17, 2012 3:44 AM, "Marek Reichenbach" <reichenbach.marek at gmail.com>
wrote:

> 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 :/
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>