Re: combine 2 tables to order by date (different fieldnames)

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 <frechdachz@planet-smart-radio.de> 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 cake-php+unsubscribe@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?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 cake-php+unsubscribe@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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.