No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
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 … | |
dear all, i have 2 tables with no common column. and i wanna add the columns of the second table to the first. but when i use the below command a cartesian product happens! [code=sql]select column1,column2,column3,column4 from table1,table2 [/code] but i want the number of rows be fixed. so i … | |
dear all, i have 2 tables with no common column. and i wanna add the columns of the second table to the first. but when i use the below command a cartesian product happens! select column1,column2,column3,column4 from table1,table2 but i want the number of rows be fixed. so i thought … | |
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 … |