Multiple occurence of record as there is only one record in table needs help

Multiple occurence of record as there is only one record in table needs help

Post by Eric » Sat, 16 Sep 2006 09:49:25


If you look into data the expr1 not match with CORP but it still shows
multiple records as account4 has only one record

TicketNum Account4 Expr1 LstVldTech TECH
CORP
4376 00000-000000-00 0 123 123 7801
4377 00000-000000-00 0 166 166 7801
4389 7844460546505 78444 323 323 7801
4378 00000-000000-00 0 551 551 7801
4377 00000-000000-00 0 166 166 7802
4389 7844460546505 78444 323 323 7802
4376 00000-000000-00 0 123 123 7803
4389 7844460546505 78444 323 323 7803
4378 00000-000000-00 0 551 551 7803
4389 7844460546505 78444 323 323 7806
4378 00000-000000-00 0 551 551 7808
4376 00000-000000-00 0 123 123 7816
4377 00000-000000-00 0 166 166 7816
4389 7844460546505 78444 323 323 7816
4378 00000-000000-00 0 551 551 7816
4376 00000-000000-00 0 123 123 7818


SELECT LastValidTech.TicketNum, LastValidTech.Account4,
Val(Left([LastValidTech].[Account4],5)) AS Expr1, tech_id.CORP FROM
LastValidTech INNER JOIN tech_id ON LastValidTech.LstVldTech =
tech_id.TECH
WHERE (((Val(Left([LastValidTech].[Account4],5)))<>[tech_id].[corp]));

Thanks.
 
 
 

Multiple occurence of record as there is only one record in table needs help

Post by Smarti » Sat, 16 Sep 2006 10:55:28

Eric, what exactly is your question?




--
Smartin