MySQL joined select

[Mark Schonewille]

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... ?