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

Whoa that's weird. I've never seen that either. I can't suggest an
explanation but I'm going to be interested in the solution.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Kaup, Chester
> Sent: 19 September 2006 18:57
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Why does the query equate these two fields?
> 
> 
> 
> 
> 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
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>