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 gi
> 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 tab
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 images.
