Hi thanks for your help.
I get this error when i try to group by:
Column meeting.title is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
I don't really recognise that message, as long as the column 'title' exists in table 'meeting' you should be ok, even though based on the previous SQL statements, you are not referencing this field directly so it should not matter.
The only thing I see wrong with this query
SELECT * FROM meeting left join staff on meeting.meetingid = staff.meetingid WHERE AND meeting.meetingid = #meetingid# group by meeting.meetingid;
is that 'WHERE AND' is syntactically wrong, and should be either:
... WHERE 1 AND ...
... WHERE meeting.meetingid = #meetingid# group by meeting.meetingid;
(lose the AND completly).