>t1, t2, t3
>10, 15, 7
>12, 6, 8
>5, 4, 11
>1st record: maximum=15
>2nd record: maximum=12
>3rd record: maximum=11
>I need the maximum of these 3 records (maximum of 15, 12 & 11) = 15.
>I guess what I need is the maximum of t1, t2 or t3 of all the records.
>
>SELECT IIF(t1>t2,IIF(t1>t3,t1,t3),IIF(t2>t3,t2,t3)) as xRet from table1
>This only gives the maximum of t1, t2 or t3 per record.
>How do I get the maximum of that maximum?
>
>Thank you all!

See Forum: Visual FoxPro Category: Databases,Tables, Views, Indexing and SQL syntax Title: Re: Show maximum of 3 columns Thread #557471 Message #557488