If you use "GROUP BY lesson.l_id" after your "ORDER BY lesson.l_id", you
will not get any records with the same lesson.l_id value.
- Jonathan
"Adv. Systems Design" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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]
