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

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Sep 19 12:57:05 CDT 2006



Lets try this again. Message reformatted itself.


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;

 
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.

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list