CFquery problem with two inner join statements
Posted on 2006-04-04
Hello I have a query that has two inner join statements. When I had only one it worked but for some reason it doesn't work now. help please...
SELECT a.systemName, a.systemNumber, a.numberofcpu, a.numberofio, a.ORG, a.division, b.director, a.type, a.comment, a.disposition, locations.Building_Number_Compaq, a.dateleftbldg, a.rmano, a.redeploy, a.lightson, a.footprint, a.srdate, a.srby, a.onallcount
FROM dbo.NSKSystemInfo a INNER JOIN dbo.director b ON a.director_id = b.director_ID, NSKSystemInfo INNER JOIN locations ON NSKSystemInfo.loc_id = locations.location_id
WHERE (a.onallcount = 'Yes')
order by a.systemname