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

Chester,

It is an odd scenario...I can't replicate those conditions(the software)...I 
would probably use a make table and create a small version of the 
dbo_DSS_Wellmaster and see if it still occurs.  I would guess that it would 
not.  I really have no idea what is causing this...but if I had to guess...I 
would look at the linking aspect of the situation.

Good luck,

Mark A. Matte


>From: "Kaup, Chester" <Chester_Kaup at kindermorgan.com>
>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 14:15:22 -0500
>
>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
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com