I linked two query(Query1, Q1) by joining three fields in my query. When I run my query, the running speed is very low(about two minutes).how I can increase running? The SQL of my Query is:
SELECT Query1.ir, Q1.ir, Q1.installevel, Query1.installevel, Q1.id_inc, Q1.setl AS Usettle, Query1.setl AS Dsettle, [Usettle]-[Dsettle] AS DifSettel, Q1.section, Q1.topread, Q1.FDATE, Q1.INCDATE.read AS Uread, Query1.INCDATE.read AS Dread, Q1.RE
FROM Query1 INNER JOIN Q1 ON (Query1.IRP = Q1.ir) AND (Query1.id_inc = Q1.id_inc) AND (Query1.Date = Q1.Date);