mysql> select channum,freqid,mplexid from channel where sourceid=1; +---------+--------+---------+ | channum | freqid | mplexid | +---------+--------+---------+ | 4.1 | 56 | 6 | | 5.1 | 35 | 3 | | 30.1 | 31 | 2 | | 2.1 | 43 | 5 | | 9.1 | 39 | 4 | | 9.2 | 39 | 4 | | 9.3 | 39 | 4 | | 11.1 | 26 | 1 | | 5.2 | 35 | 3 | | 9.4 | 39 | 4 | | 11.2 | 26 | 1 | +---------+--------+---------+ 11 rows in set (0.01 sec) mysql> select mplexid,frequency from dtv_multiplex; +---------+-----------+ | mplexid | frequency | +---------+-----------+ | 1 | 545028615 | | 2 | 575028615 | | 3 | 599028615 | | 4 | 623028615 | | 5 | 647028615 | | 6 | 725028615 | +---------+-----------+ 6 rows in set (0.01 sec) mysql> select channel.freqid,dtv_multiplex.frequency FROM channel,dtv_multiplex -> WHERE channel.mplexid = dtv_multiplex.mplexid ORDER BY channel.freqid; +--------+-----------+ | freqid | frequency | +--------+-----------+ | 26 | 545028615 | | 26 | 545028615 | | 31 | 575028615 | | 35 | 599028615 | | 35 | 599028615 | | 39 | 623028615 | | 39 | 623028615 | | 39 | 623028615 | | 39 | 623028615 | | 43 | 647028615 | | 56 | 725028615 | +--------+-----------+