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

Andy Lacey andy at minstersystems.co.uk
Wed Sep 20 10:34:07 CDT 2006


Chester
If you swap it round so the FROM is dbo_DSS_WellMaster and you JOIN to
ConfigMaster is it still the same?

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




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Why does the query equate these two fields?
Date: 20/09/06 13:47


Any chance you can copy and paste sufficient rows from the two tables so I
can recreate the situation? This one interests me but I don't want to
manufacture some pointless data and get it wrong. Probably a dozen rows from
each table would suffice.

Arthur

----- Original Message ----
From: "Kaup, Chester" <Chester_Kaup at kindermorgan.com>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Sent: Tuesday, September 19, 2006 4:54:44 PM
Subject: Re: [AccessD] Why does the query equate these two fields?

Actually they are all text fields.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Tuesday, September 19, 2006 3:35 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Why does the query equate these two fields?

What are the datatypes of ChildPID and PID?
Looks like a numeric precision problem to me.


On 19 Sep 2006 at 12:57, Kaup, Chester wrote:

>
>
> 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

--
Stuart


--
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




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

________________________________________________
Message sent using UebiMiau 2.7.2




More information about the AccessD mailing list