[ILUG] Re: mysql problem

[Mark McLoughlin]

On Wed, 29 Nov 2000, William Murphy wrote:

> Wooftie wrote:
>
> > On Tue, 28 Nov 2000, you wrote:
> >
> > Oddly the generic text implies:
> > SELECT * FROM organisation LEFT JOIN category ON
> > organisation.category_id=category.category_id;
> >
> > Are the fields category_id primary keys? If not, are they both
> > indexed & unique?
>
> Hi all,
>
> Anyone know what to do about the above behaviour in mysql? I'm not really
> sure what it means with error 1066. Possibly it's because there is a
> field in the table also called organisation. I tried the alternative
> syntax suggested and got the same result. Any ideas?
>
> Thanks in advance,
> William Murphy

Just tried out something similar and its that last syntax that works i.e.
SELECT * FROM organisation LEFT JOIN category ON
organisation.category_id=category.category_id;

you are joining the table category with the table organisation so the
category table shouldn't be included in the from clause....

....I think ;)

Good Luck,
Mark