Member Avatar for katiiiii
katiiiii 0 Newbie Poster

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)
  • 1 Contributor
  • 0 Replies
  • 44 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.