On Tue, 28 Nov 2000, you wrote:
> mysql> select * from organisation,category left join organisation on
> ERROR 1066: Not unique table/alias: 'organisation'
SELECT * FROM organisation, category
organisation, category ON
> 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
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
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!