umrf mrf mod fun rol fields of each tables are as umrf={umrfid, uid, mrfid(FK)} mrf = (mrfid(PK), modid(FK), rolid(FK), fnid(FK)) mod = {modid(PK), modname} rolid = {rolid(PK), rolname} mod = {modid(PK), fnname}
SELECT MR.MRFID,MO.Modname, RL.Rolname, FN.Fnname FROM UMRF U INNER JOIN MRF MR ON U.MRFID=MR.MRFID INNER JOIN MOD MO ON MR.MODID=MO.MODID INNER JOIN FUN FN ON MR.FNID=FN.FNID INNER JOIN ROL RL ON MR.ROLID=RL.ROLID WHERE U.UID=...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip