Hi all. I have a cakephp application with 3 tables, purchase_items, sale_items, stocks.
the schemas of the 3 tables are something like this: stocks: id. name purchase_items: id, stock_id, quantity, price sale_items: id, stock_id, quantity, price I wanted to query the available stocks, categorized by the cost (purchase_items.price). Please kindly refer to the image here. I'd like to generate a virtual field available/cost. <https://lh5.googleusercontent.com/-9o0S7EhHYF8/U2hENHe3OWI/AAAAAAAAC3c/5I4_9HAJ6qo/w821-h616-no/IMG-20140506-WA0004.jpg> -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.