manipulating a queries

[kfc]

how can i retrieve the first 10 rows of the firstnames (which is `prepodFamIO` ) found in the prepod table and the sum of the hours in a semester which is greatest the hours are found in plany table(which is `PAuditTime` ,given that the two information are in different tables.


i know if i want to select the first 10 rows of the first names i can run this query

    select * from prepod 
    limit 30;


or




    select * from prepod 
    where rownum <= 30;

and if i want to select the sum of hours which is greatest

    SELECT MAX(PAuditTime)
     AS LargestNumber
     FROM plany
     order by PAuditTime;

but how can i put them in one query ....i am using sql in access and ms sql thanks
this is a snapshot of my database but im only interested in tables plany and prepod which is on the right coner of the image

[John_G]

Hi -

For the first query, the MS Access is SELECT TOP 10 * from PrePod.
However, unless you use an order by clause, you have no way of knowing which 10 records you will get.

I don't see what you want in the second query; the example you gave will return only one record - the one with the largest value of PAuditTime. It does not sum anything. Please explain what you want to do.

John