Subject | Re: [ib-support] IF in a Query |
---|---|
Author | lester@lsces.globalnet.co.uk |
Post date | 2001-02-16T15:43:42Z |
Not quite sure what you are asking?
If you just want to chsnge the line
<< and presenze.statuspresenza = 'Presenza Feriale' >>
Why not simply enter 'Presenza Feriale' as another parameter and use the
one you want in the setup before you execute the query?
Or do you want one answer where the SUM is a group of '.statuspresenza'
settings but not all of them in which case use
presenze.statuspresenza IN ( 'Presenza Feriale',
'Presenza Feriale',
'Presenza Festivo',
'Presenza Domenicale' )
SQL can be even more difficult than english.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
If you just want to chsnge the line
<< and presenze.statuspresenza = 'Presenza Feriale' >>
Why not simply enter 'Presenza Feriale' as another parameter and use the
one you want in the setup before you execute the query?
Or do you want one answer where the SUM is a group of '.statuspresenza'
settings but not all of them in which case use
presenze.statuspresenza IN ( 'Presenza Feriale',
'Presenza Feriale',
'Presenza Festivo',
'Presenza Domenicale' )
SQL can be even more difficult than english.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services