MySQL joined select

[Marek Reichenbach]

Hi Mark, thank you for the reply.
I'm going to try it in your way.

I didn't understand one thing:
WHERE table1.key = table2.key &  WHERE table1.key = table2.key AND table2.C
< table1.B

the "table.key" is... ?


On 17 March 2012 12:56, Mark Schonewille
<m.schonewille at economy-x-talk.com>wrote:

> Hi,
>
> First, you need to create one big table. You do this with
>
> SELECT * FROM table1,table2
>
> This table will be way too big, so you need to add a way to select only
> the relevant rows from that very big table, e.g.
>
> SELECT * FROM table1,table2 WHERE table1.key = table2.key
>
> You need to test and change it until you really get only rows that make
> sense. Now you can add a condition and determine which columns to select:
>
> SELECT A,B,C,D FROM table1,table2 WHERE table1.key = table2.key AND
> table2.C < table1.B
>
> and that completes the query.
>
> --
> Best regards,
>
> Mark Schonewille
>
> Economy-x-Talk Consulting and Software Engineering
> Homepage: http://economy-x-talk.com
> Twitter: http://twitter.com/xtalkprogrammer
> KvK: 50277553
>
> Download the Installer Maker Plugin 1.7 for LiveCode here
> http://qery.us/za
>
> On 17 mrt 2012, at 11:44, Marek Reichenbach 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
>
>
> _______________________________________________
> 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
>