Stuart McLachlan
stuart at lexacorp.com.pg
Tue Sep 19 15:35:19 CDT 2006
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