I have table "master_py_engg.dbf" having fields Regno , appno, Name, matsec, physec , chesec , biosec , comsec

I want to to select the record matsec and physec as compulsory and third one is highest marks in chesec or biosec or comsec.

How to write Query?