表1结构:classroom_name、course_name、teacher_ID
表2结构:teacher_ID、teacher_name
要求在dbgrid中显示classroom_name、course_name、teacher_name
如何实现?
表2结构:teacher_ID、teacher_name
要求在dbgrid中显示classroom_name、course_name、teacher_name
如何实现?
select classroom_name, course_name,teacher_name from 表1,表2 where 表1.teacher_id = 表2.teacher_ID