SQL export multiple instances of History recrod

[cactus1000]

Is it possible to write an SQL statement to export mutliple instances of History rocords with a single Contact record?

I want to select and export some fields of a contact1 record along with 4 columns from the conthist records containing the conthist.date of the most recent conthist.activity = Call Out, conthist.date of the most recent conthist.activity = Appoint., and both conthist.date and conthist.reference for the most recent conthist.activity = Action

 

[richardy]

select * from contact1,conthist where contact1.accountno=conthist.accountno

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.