A query can select multiple values from different related or unrelated tables. e.g.

Select student.*,grades.* from students inner join grades on students.IDnum= grades.StudentID