Ysgrifennodd goose:
However how do I tell it to select JUST the first 2 entries for each
channel??
Does this help:
http://dev.mysql.com/doc/refman/5.0/en/select.html
Look (on the page) for the LIMIT clause. Not sure if it's what you want.
Peter
--
MySQL General Mailing List
For list ar
add "LIMIT 2" to the end of the statement
goose wrote:
Hi All,
I have the following SQL statement
SELECT
channel.channel_name, program_title, start_time, finish_time
FROM
program, channel
WHERE
program.channel_id='3'
AND
program.channel_id=channel.channel_id
UNION
SELECT
channel.ch
