[AccessD] Why does the query equate these two fields?

The contents of the two joined text fields are not the same but the
query equates them. Here is the query and the results. Never seen this
before.

 

SELECT DISTINCT ConfigMaster.PID AS CO2PAT, ConfigMaster.ChildPID,
dbo_DSS_WellMaster.PID

FROM ConfigMaster 

INNER JOIN dbo_DSS_WellMaster ON ConfigMaster.ChildPID =
dbo_DSS_WellMaster.PID

WHERE (((ConfigMaster.PID)="PAT 101-1"))

ORDER BY ConfigMaster.PID;

 

Funky Ptrn and Wells to Alloc

CO2PAT

ChildPID

PID

PAT 101-1

42415016740001

4241501674

PAT 101-1

42415016770001

4241501677

PAT 101-1

42415017470001

4241501747

PAT 101-1

42415017490001

4241501749

PAT 101-1

42415017610001

4241501761

 

 

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.