yes, something akin to this (assuming they are in the same schema) . sorry i cannot be more helpful with the query. the secret is the chance to retrieve multiple results, but limiting those results to one row and having them priroritized mail > users
user_query = select mail from (select mail from table where email = ? union select home as mail from users where email = ?) limit 1 On Mon, May 3, 2010 at 6:00 PM, Alex <dove...@mailswamp.com> wrote: > Hello folkz, > Is it possible to setup in dovecot-sql.conf file to run user_query > twice if its first run didn't yield any values. > And likewise don't proceed with the second run if the first user_query > execution produced the result. > I have to query two tables which specify there email messages shall be > delivered via Dovecot deliver LDA > depending on the incoming email addresses. > > Please don't question me about this setup. I inherited this mess from > the previous Network Admin. > > First query should be ran like this: > user_query = SELECT concat('maildir:/data/mail/',maildir) as mail FROM > folders WHERE email = '%u' > > If the first query doesn't yield any result the second shall be ran like > this: > user_query = SELECT maildir as home FROM users WHERE email = '%u' > > Please advise if such user_query setup is possible at all. > > Thanks in advance, > > Alex > > > -- Gabriel Millerd