[Zope] Help! SQL String

Joshi, Sunit sjoshi@ingr.com
Tue, 5 Oct 1999 08:58:55 -0500


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