Hi, Sure, just don't include B in your column list:
SELECT A,C,D FROM table1,table2 WHERE table1.key = table2.key AND table2.C < table1.B -- 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 14:42, Marek Reichenbach wrote: > Sorry Mark, one more question. Is there a way for example to do: SELECT > A,B,C,D FROM table1 WHERE A>B... BUT in the result SHOW only A column > result. HIDE B column > ? > 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
