* form (all union
queries) to the paginator and it will work.
On Tuesday, February 3, 2015 at 5:57:43 AM UTC-4:30, Gildonei Mendes
Anacleto Junior wrote:
Left join won't bring me the same results, as I said this isn't a join, I
am forcing the query to bring me the prdoduct between t1 and t2
21:22 GMT-02:00 José Lorenzo jose@gmail.com:
You can do a LEFT join, and get the sae results
On Monday, February 2, 2015 at 6:26:56 AM UTC-4:30, Gildonei Mendes
Anacleto Junior wrote:
Hi,
How could I do a cartesian product with 2 different tables in CakePHP 2.x
?
EX:
*SELECT t1.id
Hi,
How could I do a cartesian product with 2 different tables in CakePHP 2.x ?
EX:
*SELECT t1.id, t1.field, t2.id, td.field*
*FROM table1 AS t1,*
*(SELECT t2.id, t2.field FROM table2) AS t2*
*WHERE t1.id = 10*
note this isn't a join, I need these cartesian product to apply another
filter
Hello all,
I'd like to know wich of this options give me the best performance when
loading models to find data.
1. The use of use propertie on controller
- public $uses = array('Model1', 'Model2', ...);
2. The use of loadModel method inside specific method
-