MySQL joined select

[Mark Schonewille]

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.