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.
