MySQL Queries to Pull Additional Fields Data from Appointments

Hi,

I don’t know if anyone can help, but I’m trying to pull data from the Additional Fields in Appointments to display in a management program I have. It operates on MySQL commands to pull the data.

My issue is displaying the additional field data in the table alongside the correlating appointment data.

So it would display:
Appointment Date & Time | Full Name | Additional Field 1 | Additional Field 2 | Additional Field 3 | Additional Field 4

I guess I need to unserialize the additional field data then join it to the appointment data.

If you can help it would be greatly appreciated, but if not then I understand.

Thank you!

Wendy