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@serensoft.com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!