Окытушылардын фамилиялары мен олардын жумыс истейтин кафедраларынын атын шыгаратын операторды корсетиниз
- SELECT Teacher.*, Chair.Chair_NAME FROM Teacher, Chair WHERE Teacher = Chair
- SELECT Teacher.*, Chair.Chair_NAME FROM Teacher, Chair WHERE Chair_ID = Chair_ID
- SELECT Teacher.*, Chair.Chair_NAME FROM Chair WHERE Teacher.Chair_ID = Chair.Chair_ID
- SELECT Teacher.*, Chair.Chair_NAME FROM Teacher WHERE Teacher.Chair_ID = Chair.Chair_ID
- SELECT Teacher.*, Chair.Chair_NAME FROM Teacher, Chair WHERE Teacher.Chair_ID = Chair.Chair_ID
К сожалению, у нас пока нет статистики ответов на данный вопрос,
но мы работаем над этим.