Are you saying the search works with or without the join to the images table?
If it's getting to be too much code, reduce the SQL to just the minimum and get that working without the images, then try and work them in with either Jochem's or my suggestions. Ade -----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 23 January 2005 00:51 To: CF-Talk Subject: Re: How to make this query work 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 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 21/01/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:191461 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
