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
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
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