I am trying to write a query to update a table which is not directly related to another but not sure how to go about it. I have a query which joins some of the tables (qrySessionWeekdayTimes) between the two but not sure how to extend/base update query on this.
The query should update jtblSessionWeekdayStudent with all students in jtblStudentSession - linked via fldSessionID.
Would appreciate any help for this please...
The query should update jtblSessionWeekdayStudent with all students in jtblStudentSession - linked via fldSessionID.
Would appreciate any help for this please...