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
-
View this message in context:
http://www.nabble.com/Selecting-just-the-first-2-values-tf2839705.html#a7928211
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
