(OT) SQL query repeats
| From: | Adv. Systems Design | Date: | Wed, 15 Aug 2001 21:01:54 +0000 |
| Subject: | (OT) SQL query repeats | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11405@lists.php.net to get a copy of this message | ||
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/