"Daniel Dabner" <[EMAIL PROTECTED]> wrote on 03/10/2005 08:18:31 AM:
> Hi,
>
> I have been trying to construct an SQL query joining two tables for an
image
> gallery.
>
> I want to display all the IMAGE_CATEGORIES along with the first image in
> that category from the IMAGES table. The images
Hi,
I have been trying to construct an SQL query joining two tables for an image
gallery.
I want to display all the IMAGE_CATEGORIES along with the first image in
that category from the IMAGES table. The images are ordered by an integer
field called IMAGE_ORDER.
Here's what I have so far: