Select A Value Given Multiple Rows

Select A Value Given Multiple Rows

pThis is a very basic query (related to a
href=http://stackoverflow.com/questions/477006/sql-statement-join-vs-group-by-and-havingthis
one/a) I can't figure out …/p pLet's say I have a two column table like
this:/p precodeA - B 1 - 1 1 - 2 1 - 3 2 - 1 3 - 1 3 - 4 /code/pre pI want
to get all distinct As that emdo not/em have a B of 2 or 3. Using the
above example, the only results I want returned is As 2 and 3. How do I do
this?/p