Jira:Database:Get Keys and Issue IDs

select project.pkey,issuenum,jiraissue.id from jiraissue, project  where project.id = jiraissue.project and project.pkey = 'YOYODYNE' ORDER BY issuenum;