I have an Access db with 2 tables. The jobs table has jobnum, and description, and the pictures table has jobnum and pictures(file name for an image). I run my query: "Select * from jobs, pictures where job.jobnum = pictures.jobnum" and display my results:<BR><BR>if not objRS.EOF then<BR> Response.Write "<table border=1 align=center>"<BR> Response.Write "<tr><th>Job Number<th>Description<th>Pictu re</tr>" <BR> do while not objRS.EOF <BR> Response.Write "<tr><td>" & objRS("jobnum") & "</td>"<BR> Response.Write "<td>" & objRS("description") & "</td>"<BR> Response.Write "<td><img src='" & objRS("picture") & "'></td></tr>"<BR> objRS.MoveNext <BR> loop <BR> response.Write "</table>"<BR> end if<BR><BR>The problem comes when a job number has multiple images associated with it. I get a row with the same jobnum and description repeated for each image. How do I get one instance of the jobnum and description with multiple images?