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

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Sep 19 14:15:22 CDT 2006


ConfigMaster is a local table. dbo_DSS_Wellmaster is SQL server version
2007 table.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Tuesday, September 19, 2006 1:30 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Why does the query equate these two fields?

Chester,

I recreated your scenario...but not you results.  In looking at my 
example...I have 1 question...

Q:  Are "ConfigMaster" and "dbo_DSS_WellMaster" both tables in a local 
db...or are they queries/linked table/other?

Thanks,

Mark A. Matte


>From: "Andy Lacey" <andy at minstersystems.co.uk>
>Reply-To: 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: Tue, 19 Sep 2006 19:04:27 +0100
>
>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
> >
> >
>
>
>--
>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





More information about the AccessD mailing list