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