The mailing list for listmasters using Sympa

[Mark Sallee <address@concealed>]

Is there a way to run multiple sql queries from an Oracle database 
within sympa? In our existing mailing list system, we have to use a perl 
script with variables to bring in subscriber e-mails. Something like this:

my $GT = "SELECT ID FROM School WHERE Code= '$StateCode' AND LifeCycle='A';"
my $CC = "select distinct email from country_contacts where email is not 
null and contactcode = 'CC'
my $USP = "select distinct email from franchise_contact, g_franchise 
where g_franchise.franchiseid = franchise_contact.franchiseid

Then we would set the output:  All_Admin subscribers= $GT + <some more 
sql parameters> + $CC + $USP

Is this possible in sympa? Could we add multiple queries to the config 
file for a list?

Thank you.

--
Mark Sallee, Systems Administrator
The GLOBE Program - UCAR
address@concealed