I have the following tables:

Person (PK_PersonID, PersonFullName, FK_MbtiID)
Mbti(PK_MbtiID)
Dimension(PK_DimensionID, DimensionName)
MbtiDimension(FK_PK_DimensionID, FK_PK_MbtiID)

Dimension has data as followed:

PK_DimensionID, DimensionName
---------------------------------------------
E, Extraversion
I, Introversion
S, Sensing
N, Intuition
T, Thinking
F, Feeling
J, Judging
P, Perception

there are 16 mbti types from these dimensions, so the table Mbti has data as following:

PK_MbtiID
--------------
ISTJ
ISFJ
INFJ
INTJ
ISTP
ISFP
INFP
INTP
ESTP
ESFP
etc...

The link (entity relation many to many) between Mbti and Dimension is MbtiDimension which has data as following:

FK_PK_MbtiID, FK_PK_DimensionID
-------------------------------------------------
ISTJ, I
ISTJ, S
ISTJ, T
ISTJ, J
ISFJ, I
ISFJ, S
ISFJ, F
ISFJ, J
INFJ, I
INFJ, N
INFJ, F
INFJ, J
etc...

Person has one personnality,

PK_PersonID, PersonName, FK_MbtiID
---------------------------------------------------
1, John Citizen, ISTJ
2, Patrick Dupont, ISFJ
etc...


I want to retreive the John Citizen given the parameter I, S, T.

I am doing the following:

SELECT personName
FROM Person P, Mbti M, MbtiDimension md, Dimension d
WHERE P.FK_MbtiID = M.PK_PersonID
AND M.PK_MbtiID = md.FK_PK_MbtiID
AND md.FK_PK_DimensionID = d. PK_DimensionID
AND DimensionName = "Introversion"
AND DimensionName = "Sensing"
AND DimensionName = "Thinking"

It does not return anything. However when I do the following:

SELECT personName
FROM Person P, Mbti M, MbtiDimension md, Dimension d
WHERE P.FK_MbtiID = M.PK_PersonID
AND M.PK_MbtiID = md.FK_PK_MbtiID
AND md.FK_PK_DimensionID = d. PK_DimensionID
AND DimensionName = "Introversion"
OR DimensionName = "Sensing"
OR DimensionName = "Thinking"

It returns me 2 lines, I understand why but I do not understand however why I do not have any line with the and command. Am I missing something?

Could you help me, solving this.

thank you in advance.