And function inside Textjoin

[snjpverma]

I am trying to use Textjoin to concatenate all the names in Column B where column C says "Correct" and where Column D is not blank.
However, I am unable to use figure out the mistake in my AND function.

I am using this logical in the text argument of TextJoin =AND(D2:D8<>"",C2:C8="CORRECT")

However, the result of the above given formula is not a series of TRUE and False, it is just a single False.
I also Typed the above formula in bold and pressed F9 and I see only a Single False.

Whereas if I just type

=D2:D8<>""

and Press F9, I can see the series of TRUE and False
Like this: FALSE;TRUE;TRUE;FALSE;TRUE;TRUE;FALSE

Book1
	B	C	D
2	John
3	Maddy		45
4	Alisha	CORRECT	68
5	James
6	Tinu	CORRECT	84
7	Samuel		72
8	Figalar
Sheet1

Someone please tell me where I am going wrong

 

[Habtest]

AND() here returns TRUE if all rows meet the conditions of being "correct" and not blank, otherwise FALSE.
FILTER() or IF((D2:D8<>"")*(C2:C8="CORRECT"),B2:B8,"") would work here as condition.