Does this work? select t.id,t.option,t2.option from tableName t left join tableName t2 on t.id=t2.id and t2.option!=t.option where t.option="a" and isnull(t2.option);
HTH, Jed On the threshold of genius, [EMAIL PROTECTED] wrote: > I apologize for asking such a basic SQL question, but I am failing in finding > the solution... > Consider the following table: > > id | option > ----------- > 1 | a > 2 | a > 2 | b > > I want to find the ids with only a specific set of options. > For example, if I wanted to get the ids which have option a only, the query > should give me 1 as a result, not 1 and 2. > > I suspect I need to use a LEFT JOIN on the same table, but I have failed > miserably so far... > > Many thanks in advance to the SQL experts ;-). > > Jean-Luc (http://jfontain.free.fr/moodss/) > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php