quickie!

[Jamie Burns]

hi..

can someone tell me how i get the data from two tables, where table1 will have one 
row, and table2 will have many rows?

eg:

================================

table1:

    id    name

    1    barney
    2    fred
    3    wilma

table2:

    id    student_id     subject

    1    1                   english
    1    1                   cookery
    1    1                   maths
    1    1                   science
    1    2                   woodwork
    1    3                   cookery

================================

do i have to use two queries to get all this data out in usable form?

thanks,

jamie.