SQL join problem

[mattastic]

Hi,

I have this query:

SELECT * FROM meeting, staff WHERE meeting.meetingid = staff.meetingid AND meeting.meetingid = #meetingid#;

But it returns multiple values in some cases, when I would like unique values. Would joins solve this or do I need to do seperate querys?

My sql knowledge is very basic.

Thankyou

[Hack]

Try a GROUP BY on those fields that you need to be unique.

[sacx13]

SELECT * FROM meeting left join staff on meeting.meetingid = staff.meetingid WHERE AND meeting.meetingid = #meetingid# group by meeting.meetingid;


Best Regards
Adrian

[mattastic]

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.

[Brooksie155]

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 ...
or
... WHERE meeting.meetingid = #meetingid# group by meeting.meetingid;
(lose the AND completly).

[sacx13]

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



is that 'WHERE AND' is syntactically wrong, and should be either:

... WHERE 1 AND ...
or
... WHERE meeting.meetingid = #meetingid# group by meeting.meetingid;
(lose the AND completly).

You are right ... I'm wrong

Regards