Hi all, hope in your help.

I've this table in mysql:
Code:
UNITS	IND1	IND2
AAA	84%	59%
BBB	88%	56%
I need this output with the max value in table:
Code:
UNITS	IND
AAA	59%
BBB	88%
I tried this but the valur of units is incorrect:
Code:
mysql> SELECT UNITS,
	MAX(IND1) AS ind1, MAX(IND2) as ind2
FROM
	`tbl_max`;
+-------------------------+------+-----+
| UNITS                   | ind1 | ind2|
+-------------------------+------+-----+
| AAA                     | 88%  | 59% |
+-------------------------+------+-----+
1 row in set
Can you help me?
thank you