help with join

 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_at_1hostplus.com with any help that you may have

thanks Received on Tue Nov 18 2003 - 20:50:19 CET