I'm trying to run a search query on two tables. tblproductimages is a many table with a FK- prodmodelcode dropped from tblprodmodelcodes. So there can more than one image for a given model. How can I pare down the images to one image per model? Right now it comes back with too many results. This query so far is giving me wacky results. Mismatched titles and images.
SELECT tblprodmodelcodes.prodmodelcode, tblprodmodelcodes.prodmodeltitle, tblprodmodelcodes.prodsellprice, tblproductimages.prodmodelcode, tblproductimages.imagename FROM tblprodmodelcodes, tblproductimages WHERE tblprodmodelcodes.prodmodelcode = tblproductimages.prodmodelcode AND tblprodmodelcodes.prodmodeltitle LIKE '%#FORM.search#%' OR tblprodmodelcodes.prodmodeldescription LIKE '%#FORM.search#%' 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:191454 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
