MySQL joined select

Marek Reichenbach reichenbach.marek at gmail.com
Sat Mar 17 07:58:58 EDT 2012


Well, there is a unique number in both tables. Is it this what you're
talking about ?


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

> Hi,
>
> You need something to identify the rows in the tables. Somehow you need to
> know which rows belong together. If this doesn't help you, then you need to
> be more specific about the type of data in your two tables and what you are
> trying to achieve.
>
> --
> 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 12:47, Marek Reichenbach wrote:
>
> > 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... ?
>
>
> _______________________________________________
> 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
>



More information about the use-livecode mailing list