Thanks. It is only one feature per product. I removed hasOne association from 'Product' table
I already have the foreign key in the 'Product' table 'feature_id' for which I have hasOne association in the 'Feature' table. I still get the same error: $sql = "SELECT `Feature1`.`id`, `Feature1`.`name`, `Feature1`.`description`, ... FROM `features` AS `Feature1` WHERE `Feature1`.`id`=`Product`.`feature_id` " $error = "1054: Unknown column 'Product.feature_id' in 'where clause'" $out = null I could just get 'all' and foreach it through while filtering everything, but I trust there is a way to do this smartly with find() in cakephp. Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
