hello:
I have 2 tables...lesson and lesson_gle (which holds
repeating data for lesson, i.e. l_id, glenum)
the following query gets results, but there are
repeated entries (one for every repeat in lesson_gle
table)
SELECT *
FROM lesson, lesson_gle
WHERE lesson.l_id = lesson_gle.l_id
HAVING lesson_gle.glenum LIKE 'MA%'
ORDER BY lesson.l_id
Any ideas on how to get the data to not repeat?
Thanks
Luis
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]