Selecting rows as columns

11-18-2010, 04:28 PM

Hi,

Please help writing the following query. There are 3 tables. I'm trying to display all records from table apptchart and matching records from appointments table as columns. I've pasted the table structure and some data.