Re: select.. group... subselect.. whatever? Please Help..!
| From: | Daniel Convissor | Date: | Mon, 07 Aug 2000 15:31:33 +0000 |
| Subject: | Re: select.. group... subselect.. whatever? Please Help..! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-10487@lists.php.net to get a copy of this message | ||
Hi:
select
This is a MySQL question. Use that list next time. Add two lines to your
query string:
select distinct items.itemID,words.word,types.type from
types,items,words,words_items
where words.wordID=words_items.wordID
and words.word like 'a%'
and types.typeID=items.typeID
and items.itemID=words_items.itemID
group by type,word
order by type
;
Enjoy,
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
More than just answers. Solutions. (SM)
http://www.analysisandsolutions.com/
4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409