please help out if you can

Ok, 

 your going to think that I am nuts, but I am trying to join table_a
to table_b but table_b has more then one row for table_a. I would like
to get all the data on one row back. I would like to join table_a with
table_b based on p_id so for instance I would like one row with name,
phone number, data. For example the end rows would look like the
following:  in table b phone number is the row with fieldid = "03" and
the date is fieldid ="04"

+---------+--------------+-----------------+
| name    | phone        | date            |
+---------+--------------+-----------------+
| john    | 201-123-1111 | 09/24/2004      |
| sabrina | 201-133-2222 | 11/23/2003      |
+---------+--------------+-----------------+

TABLE A:
+------+---------+
| p_id | name    |
+------+---------+
| 1    | john    |
| 2    | sabrina |
+------+---------+
TABLE B:

+------+--------------+---------+
| p_id | value        | fieldid |
+------+--------------+---------+
| 1    | 201-123-1111 | 03      |
| 1    | 09/24/2004   | 04      |
| 2    | 201-133-2222 | 04      |
| 2    | 11/23/2003   | 03      |
+------+--------------+---------+

PLEASE EMAIL ME BACK AT [EMAIL PROTECTED] with any help that you
may have

thanks once again