Perhaps you want to send an email blast to everyone who bought tickets to a show listed in a specific GL code. There’s an easy way to do this.
Click on Reports | Other reports | Export email | Edit the query tab.
Enter the query like this:
select showname, mainsale.abbrev, customer.first, customer.last, customer.email from master
left join gl_codes on master.gl_code = gl_codes.gl_codes_id
left join mainsale using(master_id)
left join customer using( customer_id)
where gl_codes.gl_code='NAME OF GL CODE'
group by customer_id
order by customer.last, customer.first
Click on Export list and you will get the results.
Note: This query can be expanded in many ways. For instance, you can ask for more data or you can limit the records returned to a more stringent condition.