[Webdev] mysql problem

[Wooftie]

On Tue, 28 Nov 2000, you wrote:
> mysql> select * from organisation,category left join organisation on
> organisation.category_id=category.category_id;
> ERROR 1066: Not unique table/alias: 'organisation'

SELECT * FROM organisation, category 
LEFT JOIN 
organisation, category ON 
organisation.category_id=category.category_id;

> Any ideas what exactly is wrong and how I can fix it?
Pulled the above from an example in the OReilly MySQL book. Not
sure why the difference would be so great.

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?

I'm never joining that commune.

> Thanks in advance,
> William Murphy
Martin.