Thanks guys, got it working correct now.
It does also make things easier the way you have shown me.
"Bricklen Anderson" <bricklen13_at_hotmail.com> wrote in message
news:b416ca2d.0206141230.6c2b8d02_at_posting.google.com...
> SELECT s.school_name,c.child_name,c.dob
> FROM school s,child c
> WHERE c.school_no = s.school_no
> AND c.dob <= '01-feb-93'
> ORDER BY s.school_name, c.dob DESC; -- or omit DESC
>
> (added the aliases (s & c) to make it quicker to type, your choice...)
>
> "Messiah" <asmithster_at_hotmail.com> wrote in message
news:<_xkO8.28227$sC4.3582382_at_news6-win.server.ntlworld.com>...
> > HI
> >
> > I am using oracle 8 with sql plus to return a query which will have the
> > column headers school_name,child_name and dob.
> > What I need to know is how to get the school_name grouped and the dob in
> > order for the childs in that school.
> > It's a order by within a group, below is my attempt so far:
> >
> > SELECT school.school_name,child.child_name,child.dob
> > 2 FROM school,child
> > 3 WHERE child.school_no = school.school_no and child.dob <=
'01-feb-93'
> > 4 ORDER BY school.school_name;
> >
> >
> > This will get the school_name in order and together but the DOB in not
in
> > order.
> >
> > Any help recieved with great apprechation
> >
> > M
> >
> > --
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
> --------------------------------------------------------------------------
--
> > -----------
> > This email and all attachments have been scanned
> > with Norton Anti Virus, Total protection for Pc and Mac
> >
> > www.symantec.com
Received on Sat Jun 15 2002 - 00:58:10 CDT
