sql to get top 4 from 1 table and corresponding image from other table

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

there are two image IDs, one relating to the ITEM and the other ID is auto-generated.
If ITEM has an ID of 12 all of its images will be imageID 12, but the images all have an autoID which I can use to determin the first image posted.