Am half way through my computer lab management project. to generate the timetable automatically i've written an algorithm. and for it to work i need an sql query that can :
id lab_name subject_name.
now i looked every where, is there a command to take the first five lab_name to another table inside am(column name),and the next 5 to pm(columnname).
the above was not that tricky, i want to compare "pm" values with am so that the Subject names are not the same.
am doing my first project , am really stuck with this for hours..