Re: WOW! look at this statement!

Patrick Preuss wrote: > > Hi, > > I just discovered an undocumented (?) feature: > > select blahblah, (select field1 + field2 from table where x = y), ...> > A select in a select list. Am I a genius, or just unknowing? > > Bye, > Patrick > --- > Patrick Preuss http://home.t-online.de/home/patrick.preuss > ppr@deckard.hb.north.de > We are all working together to one end, > some with knowledge and design, and others > without knowing what they do. Marcus Aurelius Nothing undocumented here....BUT be carefull : if you place an agregate in your imbricated select, you may crash your engine. It depends on the version, but I am sure 5.02 crashes with select-select requests.... Have fun ! -- Valery Fouques valou@hotmail.com SYSADM GOSPORT-FRANCE /\\oO/\\ _ __/| \\`O.o' "355/113 -- Not the famous irrational =(_ _)= number PI, but an incredible simulation!" U