I don't know of a cakephp way off the top of my head but on the database side the best way would be using either a view table or a stored procedure.
On Thu, Feb 7, 2013 at 10:41 AM, Mathias R <[email protected] > wrote: > Hi, > > i have 2 tables (i.e. incoming_messages and outgoing_messages). saving > data in one table isn't possible. > now i want to select all entries from both tables, for getting a working > pagination, and order it by date. But each table has a different name for > date-fields, but same format. > > changing table-structure is not possible. > > is there a way to combine this tables within a request and how? > > Greetings > M. > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/cake-php?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
