I've a table with
the following structure and sample data :
Station
Emission_Freq
Reception_Freq
--------
-----------------
------------------
STAT1
192.5
193.5
STAT2
193
STAT2
194
STAT2
193.5
194.5
STAT2
195
And I would like to
select the number of frequencies, sort of count(*), for a given station and
multiply that value by 2 if the station has Emission frequency and reception
frequency and multiply by one if the station has only the emission frequency or
only the reception frequency. I don't know how to use a condition in
SQL. I'm sure that it's possible to do it but I don't know how. Can
anybody help me ?
------------------------------------------------------------------------------------
@biy @lemu
Database Administration
Engineer
France
cril.gif