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