I can't make it work right. I just ended up leaving out the images since I can make it work with a 1 table query.
The problem is these can be the results for a particular search. Keep in mind, this is only the tblproductimages portion. It ADDS to the other table returns. 2000 graytshirt.jpg 2000 bluetshirt.jpg 2000 greentshirt.jpg So it selects everything, PLUS these items which increases the results even more. if I filter by: WHERE tblpmcodes.pmcode = tblprimages.pmcode (I'm shortening this for easier reading) You'll get a return of 3 images per model. So how do I say...SELECT ALL THIS STUFF, but just show me ONE image per model? It also was mixing and matching product titles. Weird! Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191459 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
