Basic SQL

I am trying to write a sql statement that gives me the records that
have multiple values for column b, but cannot figure it out - can
someone help?

My table is as follows:

ID Value
1234 S
1234 S
1234 X
4444 S
5555 X
5555 Y

I want to see what records have two distinct values for the "Value"
column. The results of the query when running against the above data
should be as follows:

ID Value
1234 S
1234 X
5555 Y
5555 X

Any help would be appreciated.

Thanks!

.

Relevant Pages

  • Re: HELP WITH UPDATE QUERY
    ... each selected items in the list, and, in the example, make an SQL statement ... the user wants to select MULTIPLE items from this list ... query named qrProd and the list box is from that same query, ... I ASSUMED the control name was. ...
    (microsoft.public.access.queries)
  • Re: Conditional test to combine multiple records
    ... >> current sql statement. ... (or just switch to the query grid and do the ... >>> one record becaue I count the total number of shipped orders in another ... >>> over the course of multiple dates. ...
    (microsoft.public.access.queries)
  • Re: Sessions and Pagination Problem
    ... I don't get an error with the query. ... I have multiple if statements that append "AND"'s to the SQL statement ... If you click on page numbers and the prev or next links, ...
    (comp.lang.php)
  • Re: Conditional test to combine multiple records
    ... Here is my current SQL statement: ... (or just switch to the query grid and do the ... >> query for use in a shippin report. ... >> over the course of multiple dates. ...
    (microsoft.public.access.queries)
  • Re: queries return too much
    ... >when running my query i have a small problem. ... >my sql statement is ... >when i run this i get multiple returns for the same ... >partnumber and my total records come out to a crazy amout ...
    (microsoft.public.access.queries)