I have the following table which holds the info for images the user uploads.
PHOTOID (PK)
CATID (FK) -- PK in categories table
SUBCATID (FK) - PK in subcategories table
I can get the insert into and update to work fine, but how can I get the query to work so that I can only get results where all images are in one particular group set?
To see this in action:
Thanks.
_____________________________
Just Imagine.
PHOTOID (PK)
CATID (FK) -- PK in categories table
SUBCATID (FK) - PK in subcategories table
I can get the insert into and update to work fine, but how can I get the query to work so that I can only get results where all images are in one particular group set?
To see this in action:
Code:
PHOTOID CATID SUBCATID GROUPING PICNAME ISACTIVE
1 3 7 TGROUP1 1710.jpg True
2 3 7 TGROUP1 1717.jpg True
6 3 7 TGROUP1 1721.jpg True
7 3 7 TGROUP1 1730.jpg True
5 3 7 TGROUP1 1711.jpg True
8 3 7 ZGROUP2 5056.jpg True
9 3 7 ZGROUP2 5062.jpg True
10 3 7 ZGROUP2 5076.jpg True
Thanks.
_____________________________
Just Imagine.