Please help me out

[johnpalm]

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 johnpalm@1hostplus.com with any help that you may have

thanks