Re: MYSQL left joins

[Gordon Stewart]

Peter Brawley Wrote:
-------------------------------------------------------


> I'll have a lash at feeding your requirement back
> to you in language that I can understand ... you
> want to find rows where category='account',
> specifically the reference values in those rows,
> and list all the other ca.category values where
> reference=1. Is that it? If not, please elaborate.

YES, thats correct - Though i also want the title/URL fields too. But i know they will be duplicates & can deal with that after.

> Meanwhile your note that "The Checkcode field is a
> unique field combination of reference number and
> category" flags a serious redundancy in the table
> design---the concatenated field adds zero
> information, the column should be removed. To
> enforce uniqueness on those two columns, just
> define one Unique index on them.

The Checkcode IS the index :)

why delete it, just to add another index field ?