pleaseeeeeeee hepl meeeeeeee!!!!!!!!!
i have 2 tables :
time1 (noo integer,days varchar,times varchar,Tindex integer,primary key
(noo,Tindex))
timetable1_1(COn integer,coursename varchar,dayss varchar,timess varchar,
primary key(COn))
i have created a new table temptime1 and tried to fill it with the rows in time1 which their days and times are not available in timetable1_1
i used the below query but it gives me error: "Operand should contain 1 column"
QUERY:
insert into TempTime1 (NOM,Tday,Ttime,Ttindex) select * from time1 where days and times not in (select * from timetable1_1)