Kayleigh
Member
- Local time
- Today, 12:16
- Joined
- Sep 24, 2020
- Messages
- 706
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...