Re: query problem

On Fri, Mar 23, 2001 at 02:21:24PM -0000, Gyan wrote:
> Greetings! Kindly lemme know how do u sort a table on some
> field...please talk about the command that does it. Thanx.

the sorting is done in the select command (see the docs under
'SELECT' for more detail):

select p.fullname,e.salary,d.name as dept,d.supervisor
from person p,employee e,department d
where p.id=e.id and dept.id=e.dept
ORDER BY dept,fullname

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'

will(at)serensoft(dot)com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!