Re: Select data that has no related categories...

2002-05-29 Thread Victoria Reznichenko
Victor, Wednesday, May 29, 2002, 12:01:31 AM, you wrote: VSA Tells a great deal about how confused I am... VSA I've a database with three tables, one with image data, one with VSA categories and one table which helps me to have several categories per VSA image... VSA The following SQL gives

Select data that has no related categories...

2002-05-28 Thread Victor SpÄng Arthursson
Tells a great deal about how confused I am... I've a database with three tables, one with image data, one with categories and one table which helps me to have several categories per image... The following SQL gives me _all_ the images that has at least one category associated: SELECT

RE: Select data that has no related categories...

2002-05-28 Thread Moyer, Andy
SELECT images.filename, images.path, images.desc, categories.name FROM images, relate, categories WHERE public = 1 AND relate.fromid = images.id AND relate.toid = categories.id But what I need help with is getting all the images that has no categorie associated with them in the table