How can I convert 2 queries into single query

[Nutty]

I have the following table and I try to extract all lines with the B value for the fields RefD and all lines whose RefA fields to the value B and the value of their RefD fields is among those with value B for the fields RefD. If my table contains:
RefA ..... RefD
..K ........W
..Z ....... E
..A ........ B
..C ........ B
D ........ B
B ........ C
B ........ H

the result is that waiting

RefA RefD ....
A...... B
C ..... B
D ..... B
B ..... C


At the moment I made the two requests
the first on my table

SELECT * FROM TABLE WHERE RefD=B

And the second on the outcome of the requests

SELECT * FROM TABLE WHERE RefD=A OR RefD=C OR RefD=D

I want to know if it is possible to do this in one query.

[Modifier]

When you write

extract all lines with the B value for the fields RefD and all lines whose RefA fields to the value B and the value of their RefD fields is among those with the value B for the fields RefD.

I think from reading your example and your code that you wanted to write:

extract all lines with the B value for the fields RefD and all lines whose RefA fields to the value B and the value of their RefD fields is among those not having value B for the fields RefD.

If so:

  SELECT *  
  FROM TABLE  
  WHERE RefD = 'B' 
  OR (RefA = 'B' AND RefD <> 'B')

[XSI]

A union is sufficient

SELECT * FROM TABLE WHERE RefD=B
UNION 
SELECT * FROM TABLE WHERE RefD IN (A, C, D)

[Nutty]

@ Modifier

No it does not work because if you apply this solution to my example the line
"B ........ H" will appear which is not needed.

@ XSI

Except that I do not know the values A, C, D in advance, that is why I make 2 requests at this time.

[XSI]

Use a subquery:

SELECT * FROM TABLE  
  WHERE RefD = B OR (RefA=B AND RefD IN ( SELECT RefD FROM TABLE WHERE RefD=B))