I have two tables in data base
Modules (have modules like admission, result, accounts etc )
schools (have school data which want to purchase these Modules)
and a 3rd table is as
access tble(Show data about which school can access which modules )
acces table will take the school id and module id to show the corresponding record
how to write the query to get the school id from school table and module id from module table and store it in to access table
thnks in advance to any helping friend