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 where table1.item = 'some number' How should I structure the query? Thanks David
