MSaccess query to access random value from database
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I am creating one website for external exam duty allotment.I am using msaccess database and jsp to connect it,html and css. I have 2 tables room and facutly details. Attribute of room table are total_rooms_available, session and date. Attribute of faculty details are faculty_id,faculty_name experience, designation,mail_id and phone_no. my question is how to fecth faculties randomly based on no of rooms available i.e (if total_rooms_available is 10 i have to fetch 10+3 faculties randomly from facutlydetails table)