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