Re: Retrieving only the first record in a grouped query

2005-03-10 Thread SGreen
"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

Retrieving only the first record in a grouped query

2005-03-10 Thread Daniel Dabner
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: