Si usas la v2 tendrás que usar este metodo:
$this->Customer->query("SELECT * FROM pictures LIMIT 2;");
http://book.cakephp.org/2.0/en/models/retrieving-your-data.html#model-query
Te recomiendo que uses la versión 3.
Enviado con MailTrack
<https://mailtrack.io/install?source=signature&lang=es&referral=christian.quis...@gmail.com&idSignature=23>
Saludos
Christian Quispe
*Geek and Developer*
*Miembro: * *GDG Lima (Google Developer Group Lima)*
*Portafolio: www.oxicode.io
<https://mailtrack.io/trace/link/17189edfdc13625414302bd0c1313dc99e062b15?url=http%3A%2F%2Foxicode.io&signature=efdec3bbffdbed8e>*
*¿A quién le enseñan sus aciertos?, si yo aprendo de mis errores
constantemente...*
2015-07-15 7:06 GMT-05:00 Hugo Fabricio <m...@hugofabricio.com>:
> Hi,
>
> Can anyone help me for this query in cakephp 2 format?
>
> *SELECT * FROM `app_customers` AS `Customer` WHERE id IN ( SELECT
> DISTINCT (customer_id) FROM `app_buildings`)*
>
> Thanks
>
> --
> 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.
>
--
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.
