[ILUG] Re: mysql problem
mark at skynet.ie
Wed Nov 29 19:05:16 GMT 2000
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
you are joining the table category with the table organisation so the
category table shouldn't be included in the from clause....
....I think ;)
More information about the ILUG