Here is the query I'm using:
select m.transaction_number, m.transmittal_number, m.received_from, d.fy_applied,
d.ae_state_basic as ae_state_basic,
d.ae_state_performance as ae_state_performance,
d.ae_state_public_assistance as ae_state_public_assistance,
d.ae_federal_basic_admin as...