[Zope] Help! SQL String

5 Oct 1999


      Hello
	I'm using an SQL query which fetches data from two tables like:
	select ta.Name, tb.DeptNo, tb.Title, tb.Salary
	from tblFacts ta, tblEmployee tb
	where ta.EmployeeID = tb.EmployeeID
	order by DeptNo

	Now when I use the query in a DTML doc. how do I reference the 
	columns, will it be like ta.Name, tb.DeptNo
	or will it be Name & DeptNo

thanks
Sunit

[Zope] Help! SQL String

Joshi, Sunit