SQL select query for returning all roles and permissions

SELECT * FROM role r left join role_permission rp on rp.rid = r.rid

SELECT * FROM role r left join permission rp on rp.rid = r.rid

Are you using d6 or d7 ? I'm not sure how this could be done in d6, as perm field is permission table is a longtext; holding permission strings as comma separated value. For d7 the following SQL could work,
SELECT name, permission FROM role r left join role_permission rp on rp.rid = r.rid order by name, permission

Yes Thermal you are correct.
Those permissions are coming from modules only.Each module will be having its own permission.
And those are returning from hook_perm.
You can check this url hook_perm

Hi,

I'm trying to write an Sql query on a D6 database to return users and their profile values. My problem is getting profile values to return as separate fields (columns) in the resulting rows, since profile data is saved in the profile_values table as children, identified by fid.

I've tried Group_concat but it is not a solution. Profile csv module is not sufficient either. I'd like to have an output like this:

User | Firstname | Lastname | Address | City | State | Zip | etc |

If anyone has done this as a query, please let me know.

Thanks,
Thermal