Re: SQL QUERIES

[Stalin Lema]

I have a table for each one that looks like this (don't worry about the syntax)

create table term;

term_desc archer(15);

create table course;

course_name archer(8);

create table location

bldg_code;
room archer(4)


I need to display all this that was taught by one member only. The result could be like this.

Kim Smith Intro to programming room 201 ...