Help with Exporting Alarm Status Table

Would there be a way to collect this data via a SQL query with a Join on the alarm tables and the tables that contain the clear time and ack’ed by data?