[php-list] getting a value from a join

[David]

Hi

I have 3 tables which each contain a field named discount  

table1.discount
table2.discount
table3.discount

I would like to do a join on the 3 tables and get the highest discount
value of the three.  

How should I structure the query?

Thanks

David