[SOLVED] two queries at once?

[michaellunsford]

The main query is pretty simple. The catch is, I only want DISTINCT `clientimages`.`event_name` fields. So, I'm thinking I need to embed a DISTINCT query inside the following?

[code]"SELECT `clientimages`.*,`options`.`value` WHERE `clientimages`.`event_name` = `options`,`keyfield`"[/code]

[effigy]

Instead of[tt] `clientimages`.*[/tt], I think you need to specify the[tt] DISTINCT [/tt]for[tt] event_name[/tt], and then list the other fields.

[michaellunsford]

not terribly good at this, here's what I have -- but it's returning every record:

[code]SELECT DISTINCT  `clientimages`.`event_name`,  `clientimages`.`caption` ,  `options`.`value`
FROM  `clientimages` ,  `options`
WHERE  `clientimages`.`event_name` =  `options`.`keyfield` [/code]

[effigy]

I think I'm wrong here:[tt] DISTINCT [/tt]is affecting the whole sets of fields, not just [i]a[/i] field. See if the some of the User Comments [url=http://dev.mysql.com/doc/refman/5.0/en/select.html]here[/url] are helpful; I saw two that specifically dealt with this.

[fenway]

Correct -- DISTINCT is not a function, it's a modified to SELECT.  I'd suggest a GROUP BY clause, but why do you duplicate records, and which one would you want MySQL to "keep"?

[michaellunsford]

the records aren't duplicate, it's just a linked field. like a category. So I only want one from each category returned.

anyway, the "group by" has done the trick. Thanks!