Wordpress Metadata and Value

[Jay 147]

Hi,
I am trying to get some data from my wordpress tables that and are stored in a meta_key and meta_value fields
What i am wanting it to do it make a view of the data as a table for exporting to another database.
the table is wp_usermeta fields are (umeta_id, user_id, meta_key, meta_value)
so i have something like:
select n1.user_id, n1.meta_value as nickname from cala_usermeta where meta_key='nickname'
select n1.user_id, n1.meta_value as firstname from cala_usermeta where meta_key='first_name'
select n1.user_id, n1.meta_value as lastname from cala_usermeta where meta_key='last_name'

So I need to have the end result a single view (user_id, nickname, firstname, lastname)
any help would be greatly appreciated. Thanks