> > SELECT role.roleid, role.rolename, userrole.userID > FROM Role AS role > INNER JOIN userrole AS userrole ON role.roleid = > userrole.roleid WHERE role.applicationid = 39 AND userrole.userID = 84 >
It gives me what I could always get (read first email) which is everything that links both, BUT it doesn't give me every role. Have I stumped everyone on this list? Paul -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
