I want to loop through the list of table names below the query and compare similar table names to see if targets are not equal.
--------------------------------------------------------------------
SELECT [compareCVN79 Dwg 04-26-10].Dept, [compareCVN79 Dwg 04-26-10].Target, [compareCVN79 Dwg 05-03-10].dept ,[compareCVN79 Dwg 05-03-10].Target
FROM [compareCVN79 Dwg 04-26-10] INNER JOIN [compareCVN79 Dwg 05-03-10] ON
[compareCVN79 Dwg 04-26-10].Confirmation = [compareCVN79 Dwg 05-03-10].Confirmation
WHERE ((([compareCVN79 Dwg 05-03-10].Target)<>[compareCVN79 Dwg 04-26-10].[Target]));
Code:
table_namesidNameDate1
compareCVN79 Dwg 04-26-104/26/2010
compareCVN79 Dwg 05-03-105/3/2010
compareCVN79 Dwg 05-10-105/10/2010
compareCVN79 DZ 04-26-104/26/2010
compareCVN79 DZ 05-03-105/3/2010
compareCVN79 LOE 04-26-104/26/2010
compareCVN79 LOE 05-03-105/3/2010
compareCVN79 LOE 05-10-105/10/2010
compareCVN79 LYS Dwg 04-26-104/26/2010
compareCVN79 LYS Dwg 05-03-105/3/2010
compareCVN79 LYS Dwg 05-10-105/10/2010
compareCVN79 LYS LOE 04-26-104/26/2010
compareCVN79 LYS LOE 05-03-105/3/2010
compareCVN79 LYS LOE 05-10-105/10/2010
compareDwg 4-19-104/19/2010
compareDwg 4-26-104/26/2010
compareDwg 5-10-105/10/2010
compareDwg 5-3-105/3/2010
compareDZ 4-19-104/19/2010
compareDZ 4-26-104/26/2010
compareDZ 5-10-105/10/2010
compareDZ 5-3-105/3/2010
compareSORD 4-19-104/19/2010
compareSORD 4-26-104/26/2010
compareSORD 5-10-105/10/2010
compareSORD 5-3-105/3/2010
compareUnbudget Drawings 4-26-104/26/2010
compareUnbudget Drawings 5-10-105/10/2010
compareUnbudget Drawings 5-3-105/3/2010
compareUnbudgeted DZs 4-26-104/26/2010
compareUnbudgeted DZs 5-10-105/10/2010
compareUnbudgeted DZs 5-3-105/3/2010
compareUnbudgeted SORDs 4-26-104/26/2010
compareUnbudgeted SORDs 5-10-105/10/2010
compareUnbudgeted SORDs 5-3-105/3/2010