>
> SELECT a.roleid, a.rolename, b.userid
> FROM role a
> LEFT JOIN userrole b
> ON a.roleid = b.roleid
> WHERE a.applicationid = 39
> OR b.userid = 84
>
> ?
>
Returns
147 Guest 77
145 Application Editor 55
146 User Editor 55
147 Guest 55
148 editor 55
149 nother 58
149 nother 75
147 Guest 61
147 Guest 76
147 Guest 65
145 Application Editor 59
145 Application Editor 84
148 editor 84
147 Guest 84
Which isn't quite right, although it's close.
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]
