- 1
- 2
- 3
- 4
- 5
- 6
select books.title,subjects.title from books,subjects,subjects_specialty,specialty,chair
where (books.subject_id=subjects.id)
and (subjects.id=subjects_specialty.subject_id)
and (subjects_specialty.specialty_id=specialty.id)
and (specialty.chair_id=chair.id)
and (chair.title='КИИ');