help me combine these queries please

[cahickm2]

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?

 

[Dan Waterloo]

I think you want to do a UNION of the two queries. The syntax of the UNION query would be

SELECT *
FROM [Nortel TTI Trunk]
WHERE ((([Nortel TTI Trunk].TkgShortName) In ('LEAVCHLCMODOD','FREDEKGRWVDID','LEAVCAMEMO911','LEAVCLINMO911')))

UNION

SELECT *
FROM [Nortel TTI Trunk]
WHERE NumofAvailCirc>1
ORDER BY SwitchName, TkgShortName, TotalTraffic DESC;

 

[cahickm2]

Thanks a lot. I knew it was going to be something easy and that I should have known it but is has been a couple year since I used SQL.