Hello Guys I have this monster of a query, works like a champ in Access 2000, but will not in CFMX. What is wrong with this puppy?
SELECT Products.ID, Products.Name, Products.Category, ProductSKUs.UnitPrice FROM Products INNER JOIN ProductSKUs ON Products.ID = ProductSKUs.ItemID WHERE (([Category]="Out Door Essentials")) Thank You http://www.yippykia.com Camilo Trevino Senior Web Developer 949-646-1890 2445 Elden Ave Suite L Costa Mesa, CA 92627 ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
