Hello All First of all thanks for replying to my earlier mail where I'm trying to use the SQL method: select ta.Name as Name, tb.DeptNo as DeptNo, tb.Title as Title, tb.Salary as Salary from tblFacts ta, tblEmployee tb where ta.EmployeeID = tb.EmployeeID order by DeptNo The SQL runs fine when tested in Zope, however when used in a DTML doc, I get this error message Error Type: KeyError Error Value: Name This is my DTML doc <table border="1"> <tr> <th align="center"><strong>Name</strong></th> <th align="center"><strong>Department</strong></th> <th align="center"><strong>Title</strong></th> <th align="center"><strong>Current Salary</strong></th> </tr> <--#in sqlShowEmployees--> <tr> <td><!--#var Name--></td> <td><!--#var DeptNo--></td> <td><!--#var Title--></td> <td><!--#if expr="Salary > 45000"--> <font color="FF0000"> <center>$<!--#var Salary--></center> </font> <!--#else--> <center>$<!--#var Salary--></center> <!--#/if--> </td> </tr> <--#/in--> </table> Any ideas..??? thanks Sunit