On Thu, 2006-01-12 at 12:58, Angshu Kar wrote: > Hi, > > Can I use Select max(a field returned from another query)? > say, another query returns say 10,1,2,3,6,7
Does this form help you: select max(a) from (select 1 as a union select 2 union select 3) as b; ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly