Ok, here’s my query:
SELECT
transponders.orb_pos, satellites.sat_name, transponders.frequency, transponders.symbol_rate, transponders.polarisation, transponders.fec_inner, transponders.DVB_system, transponders.modulation
FROM
transponders, satellites
WHERE
transponders.orb_pos = satellites.orb_pos
AND
transponders.feed = 0
ORDER BY
transponders.orb_pos, transponders.frequency ASC
I want my result to also contain a variable call “band”. If “transponders.frequency” is less than 10000 it will contain the string “C”, otherwise it will contain the string “Ku”. Or would I be better off just running a second query with an additional AND clause?