Multiple OR Statements

B

BAC

We are testing a new procedures/process for extracting data from multiple
sources .
To test the results we use a query comparing the two tables and test several
variables with
SELECT [InfoleaseFCS Table].Info_Acct, [InfoleaseFCS Table].FCS_Co,
[InfoleaseFCS Table].FCS_Acct, [InfoleaseFCS Table].FCS_Cent, [InfoleaseFCS
Table].Co_name, [InfoleaseFCS Table].Info_Detail, [InfoleaseFCS
Table].Info_Gl, [InfoleaseFCS Table].Insight_Gl, [InfoleaseFCS Table].[Final
Sort], "Candy" AS tabl1, [InfoleaseFCS Table1].Info_Acct, [InfoleaseFCS
Table1].FCS_Co, [InfoleaseFCS Table1].FCS_Acct, [InfoleaseFCS
Table1].FCS_Cent, [InfoleaseFCS Table1].Co_name, [InfoleaseFCS
Table1].Info_Detail, [InfoleaseFCS Table1].Info_Gl, [InfoleaseFCS
Table1].Insight_Gl
FROM [InfoleaseFCS Table] INNER JOIN [InfoleaseFCS Table1] ON [InfoleaseFCS
Table].Info_Acct = [InfoleaseFCS Table1].Info_Acct
WHERE ((([InfoleaseFCS Table].FCS_Co)<>[InfoleaseFCS Table1].[FCS_Co])) OR
((([InfoleaseFCS Table].FCS_Acct)=[InfoleaseFCS Table1].[FCS_Acct])) OR
((([InfoleaseFCS Table].FCS_Cent)<>[InfoleaseFCS Table1].[FCS_Cent])) OR
((([InfoleaseFCS Table].Co_name)<>[InfoleaseFCS Table1].[Co_Name])) OR
((([InfoleaseFCS Table].Info_Detail)<>[InfoleaseFCS Table1].[Info_Detail]))
OR ((([InfoleaseFCS Table].Info_Gl)<>[InfoleaseFCS Table1].[Info_Gl])) OR
((([InfoleaseFCS Table].Insight_Gl)<>[InfoleaseFCS Table1].[Insight_Gl]))
ORDER BY [InfoleaseFCS Table].FCS_Co, [InfoleaseFCS Table].FCS_Acct,
[InfoleaseFCS Table].FCS_Cent;

Howevere the query is returning just about every row and the only unequal
field is the Co_name field in only about half the rows returned

Why am I getting rows that have no errors?

TIA

Bruce
 
Top