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