that goes back to the original part of this thread, this would be my problem too and why i would have done it like i originally stated, so much easier, i dont get it this way, so much more work, doesnt make sense to me ????
---------------------------------------- From: Will Tomlinson <[EMAIL PROTECTED]> Sent: Saturday, January 22, 2005 8:49 PM To: CF-Talk <[email protected]> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:191460 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
