SELECT *
FROM [Nortel TTI Trunk]
WHERE ((([Nortel TTI Trunk].TkgShortName) In ('LEAVCHLCMODOD','FREDEKGRWVDID','LEAVCAMEMO911','LEAVCLINMO911')));
SELECT *
FROM [Nortel TTI Trunk]
WHERE NumofAvailCirc>1
ORDER BY SwitchName, TkgShortName, TotalTraffic DESC;
I need help combining these queries. The first query returns information that is required regardless. the second returns information where the number of available circuits is greater then 1. I need to combine these queries together. The info from the first query has either a 1 or 0 in the number of available circuits column, but i am required to show them. can someone help?
FROM [Nortel TTI Trunk]
WHERE ((([Nortel TTI Trunk].TkgShortName) In ('LEAVCHLCMODOD','FREDEKGRWVDID','LEAVCAMEMO911','LEAVCLINMO911')));
SELECT *
FROM [Nortel TTI Trunk]
WHERE NumofAvailCirc>1
ORDER BY SwitchName, TkgShortName, TotalTraffic DESC;
I need help combining these queries. The first query returns information that is required regardless. the second returns information where the number of available circuits is greater then 1. I need to combine these queries together. The info from the first query has either a 1 or 0 in the number of available circuits column, but i am required to show them. can someone help?