Re: Multi-Table Query

I guess I wasn't as brain-dead as I thought I was.  I figured it out.

AliR.

"AliR (VC++ MVP)" <AliR@[EMAIL PROTECTED]
> wrote in message 
news:3q9rh.67831$wP1.44477@[EMAIL PROTECTED]
>I am trying to use the multi-table query, but just can't seem to wrap my 
>head around it.
>
> I have 2 tables. One has two fields, SchoolID, and StudentID, which is a

> look up of what student is in which school.  The Student Table has a 
> StudentID along with First name and last name.
>
> What I want to query is all the students that belong to schoolID = 1 and

> their last name starts with A.
>
> In the past when all the students belonged to the same school all I had
to 
> do was search for
>
> UPPER(LNAME) = 'A'
>
> Now I am having a problem creating the relations and the query to use
the 
> two tables.
>
> Any help would be greatly appreciated.
>
> Thanks
> AliR.
>