Simple yet elagent, why didn't I think of that?

Thanks
Jim


>Yes. A view can reference multiple tables. Just include both tables in the FROM clause.
>
>SELECT track.*
>FROM track INNER JOIN schoolyear ON track.schoolyear = schoolyear.nschoolyear
>. . .
>
>-Mike