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...