hi,

thank you very much for this I had tested the wrong sample earlier but this helped me verify the date runs.

big Thumbs up !

the procedure should return the list of courses that the newly assigned trainer can teach.

I suppose it should look something like this

result window

I have attached a snippet.

Create Table tTrainer (

TrainerIDchar(10) primary key not null,

tsname varchar(30) not null,

tfname varchar(30),

Titlevarchar(10),

taddressvarchar(50),

temailvarchar(40));

Create Table tRoom(

roomnovarchar(4) primary key not null,

Buildingno int not null,

SetupID varchar(4) not null,

Foreign key(Buildingno) references tBuilding(Buildingno),

Foreign key(SetupID)...