Hi guys,
I am trying to put together a union query to combine two other queries. The existing queries run in less than a second but combining them takes 5-10 minutes.
I've tried "UNION ALL" as well but get the same thing.
Can anyone see the issue?
Thanks
Query 1:
Query 2:
Union:
I am trying to put together a union query to combine two other queries. The existing queries run in less than a second but combining them takes 5-10 minutes.
I've tried "UNION ALL" as well but get the same thing.
Can anyone see the issue?
Thanks
Query 1:
Code:
SELECT Member.*
FROM Member
WHERE Member.IDNo = "AAAAA" AND uniqueRef IN (SELECT uniqueRef FROM Member WHERE IDNo = "BBBBB");
Query 2:
Code:
SELECT Member.*
FROM Member
WHERE Member.IDNo = "BBBBB" AND uniqueRef IN (SELECT uniqueRef FROM Member WHERE IDNo = "AAAAA");
Union:
Code:
(SELECT Member.*
FROM Member
WHERE Member.IDNo = "AAAAA" AND uniqueRef IN (SELECT uniqueRef FROM Member WHERE IDNo = "BBBBB"))
UNION
(SELECT Member.*
FROM Member
WHERE Member.IDNo = "BBBBB" AND uniqueRef IN (SELECT uniqueRef FROM Member WHERE IDNo = "AAAAA"));